Connection to a database from your .net application is quite simple. This function Returns a DataTable datatype. You can add any other parameters to it, such as database name, table name, etc.. For the moment, it doesn’t take any parameter.
using System.Data;
using System.Data.OleDb;
Protected DataTable GetAllUsers()
{
string strConn, strSQL;
strConn = "Provider=Microsoft.JET.OLEDB.4.0; data source=C:/employees.mdb";
strSQL = "SELECT * FROM users, " ;
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, strConn);
DataSet ds = new DataSet();
DataTable dt= new DataTable();
da.Fill(dt);
Return dt;
}



