C#: SQL Server Connection String

by

Well, what database are you using? For example, SQLServer? Oracle? MySQL?

In SQLServer, at least, the connection string is defined in the web.config, or app.config, and has syntax similar to the following:

<appSettings>
<add key="ConnectionStringName" value="AppName"/>
</appSettings>
<connectionStrings>
<add name="AppName" connectionString="Data Source=DataSourceName; Initial Catalog=DataBaseName; user id=UserID; password=Password" providerName="System.Data.SqlClient"/>
</connectionStrings>

Something like that. There’s probably something I’m missing, but without testing it out in your code, I’m blanking on what that might be.

This how you extract the connection string from your code if the connection string is properly set in the web.config:

 var connectionString = ConfigurationManager.ConnectionStrings["AppName"].ConnectionString;

More Related Contents:

  1. 'Must declare the scalar variable "@thisuser".' [closed]
  2. SQL Server Char/VarChar DateTime Error [closed]
  3. How can I solve error in connection string in C#?
  4. Monitor all print queue job
  5. Remove weird characters ( A with hat) from SQL Server varchar column
  6. Why should I use int instead of a byte or short in C#
  7. How to deploy application with sql server database on clients
  8. What represents a double in sql server?
  9. How to catch SQLServer timeout exceptions
  10. Use of SqlParameter in SQL LIKE clause not working
  11. SqlParameter does not allows Table name – other options without sql injection attack?
  12. Is there any way to embed power bi reports and dashboards in vb.net or C# desktop application with sql server 2008 database?
  13. How can I retrieve a list of parameters from a stored procedure in SQL Server
  14. DateTime’s representation in milliseconds?
  15. What’s the best way to test SQL Server connection programmatically?
  16. Entity Framework 6 transaction rollback
  17. Using SqlDataAdapter to insert a row
  18. How to pass string array in SQL parameter to IN clause in SQL
  19. Horrible performance using SqlCommand Async methods with large data
  20. The parameterized query ….. expects the parameter ‘@units’, which was not supplied
  21. Unable to load SqlServerSpatial.dll
  22. Query validation using C#
  23. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  24. How to get nullable DateTime out of the database
  25. How to get efficient Sql Server deadlock handling in C# with ADO?
  26. Cyrillic encoding in C#
  27. Generating sql code programmatically
  28. Accessing System Databases/Tables using LINQ to SQL?
  29. ‘Must Declare the Scalar Variable’ Error When Passing a Table-Valued Parameter to a Parameterized SQL Statement
  30. What does a timestamp in T-Sql mean in C#?

Leave a Comment