Free Programming Tutorials & Source Code

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;

}