How can I set an SQL Server connection string?

by

.NET DataProvider — Standard Connection with username and password

using System.Data.SqlClient;

SqlConnection conn = new SqlConnection();
conn.ConnectionString =
  "Data Source=ServerName;" +
  "Initial Catalog=DataBaseName;" +
  "User id=UserName;" +
  "Password=Secret;";
conn.Open();

.NET DataProvider — Trusted Connection

SqlConnection conn = new SqlConnection();
conn.ConnectionString =
  "Data Source=ServerName;" +
  "Initial Catalog=DataBaseName;" +
  "Integrated Security=SSPI;";
conn.Open();

Refer to the documentation.

More Related Contents:

  1. What is the connection string for localdb for version 11
  2. run .sql file over a collection of databases on an instance
  3. How to pass an array into a SQL Server stored procedure
  4. How to pass table value parameters to stored procedure from .net code
  5. Call a stored procedure with parameter in c#
  6. Execute a large SQL script (with GO commands)
  7. Calling stored procedure with return value
  8. Execute Insert command and return inserted Id in Sql
  9. Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
  10. C# Equivalent of SQL Server DataTypes
  11. Adding multiple parameterized variables to a database in c#
  12. Getting data from stored procedure with Entity Framework
  13. ExecuteNonQuery: Connection property has not been initialized.
  14. SQL command INSERT is working but the data not appear in table
  15. Return value from SQL Server Insert command using c#
  16. How can I insert 10 million records in the shortest time possible?
  17. How to pass sqlparameter to IN()? [duplicate]
  18. How to connect to database from Unity
  19. How to insert a data table into SQL Server database table?
  20. Connection timeout for SQL server
  21. Calculated column in EF Code First
  22. MultipleActiveResultSets=True or multiple connections?
  23. Generate class from database table
  24. What is passing parameters to SQL and why do I need it?
  25. Is it better to execute many sql commands with one connection, or reconnect every time?
  26. Upload CSV file to SQL server
  27. SQL Server: Dynamic where-clause
  28. How to retrieve binary image from database using C# in ASP.NET
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How do I connect to a SQL database from C#?

Leave a Comment