First is to create the connection string. You can store your connection string in a String data type.

Things that will be needed in your connection string is your Network Library, Data Source or the location of your database(ip), database the name of the database to be used, user id which is the username and lastly password.

For Example:

String cs = @”Network Library=DBMSSOCN;Data Source=localhost;database=test;User id=karlpox;Password=pogi;”

Next is to open a SQL connection. But you must import the sqlclient by adding this line to the top of your code.

using System.Data.SqlClient;

For Example:
SqlConnection c = new SqlConnection(cs);

Well these will let C# connect to the database. SQL statements not included in this post.