The following code sample shows that how we can use create dataset or datatable from Access database:
DataSet ds=new DataSet();
OleDbConnection con; // create connection
OleDbCommand com; // create command
con = new OleDbConnection(“Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\\Program Files (x86)\\ParamSave.mdb”);
com = new OleDbCommand(“Select * from tblcatagory”, con);
con.Open(); // open the coinnection
OleDbDataAdapter oadap=new OleDbDataAdapter(com);
oadap.Fill(ds);
con.Close();