Connection to the MS SQL Database in C#

Connection to the MS SQL Database in C#

Well,

When you are going to use SQL with C# coding the very first thing you have to do is import the name spaces.

You have to import following components.

using System.Data.SqlClient;

Then in the coding section you have to write this code to connect with the database.

try
{
               SqlConnection myCon = new SqlConnection(@"<connection string>");
               //myCon is the sqlConnection type variable.

             myCon.Open()
            //this is how the created connection is opened

           //
           //
           //Use these lines to write other codes that you need to write.
           //
           //

           myCon.Close()
         //This is how the close an opened connection.
}
Catch
{
         messageBox.Show(“The database connectivity has an error”)
}

(The try catch block is not mandatory)