Connect the Database

Using Oledb

Establishing Connection

OleDbConnection OCon=new OleDbConnection(StrCon);
//StrCon is Connection string
OCon.open();
//Some database transactions
OCon.Close();

Using SqlClient

Establishing Connection

SqlConnection OCon=new SqlConnection (StrCon);
//StrCon is Connection string
OCon.open();
//Some database transactions
OCon.Close();