C-sharp, how to create a SQL connection

This article will show you how to create a SQL Client connection in C#. A connection is needed when an application interface or web interface want to connect to the MS SQL database. System.Data.SqlClient namespace is needed to create a SQL connection.

We are using the connection builder to do this so first create a connection builder.

SqlConnectionStringBuilder connBuilder = new SqlConnectionStringBuilder();

connBuilder.IntegratedSecurity = false; //Set this to false if we want to use window authentication

connBuilder.DataSource = @".\SQLExpress";

connBuilder.InitialCatalog = "TestDb"; //Your database name

SqlConnection conn = new SqlConnection(connBuilder.ConnectionString);

We now have a connection using the above database information.

Using the connection:

conn.OpenConnection();

//You can use the connection to query, update, insert, etc..

conn.CloseConnection(); //Make sure you remember to close the connection