Good morning everyone, i was wondering if anyone has a simple example on how to connect to MS Access whether by registration or displaying data? Thank you
public DataSet GetData()
{
connect();
adpt = new OleDbDataAdapter("Select * From Registration", oleConn);
dset = new DataSet();
dset.Clear();
adpt.Fill(dset, "Registration");
if (oleConn.State == ConnectionState.Open)
{
oleConn.Close();
}
return dset;
}
Thanks
Subhash
Please, Mark as Answer if this reply helped you.
Marked as answer by colol on Sep 10, 2012 03:41 AM
colol
Member
117 Points
542 Posts
connecting to MS Access
Sep 10, 2012 12:47 AM|LINK
Good morning everyone, i was wondering if anyone has a simple example on how to connect to MS Access whether by registration or displaying data? Thank you
subhash.shel...
Contributor
2137 Points
487 Posts
Re: connecting to MS Access
Sep 10, 2012 01:43 AM|LINK
Hi,
You can connect database using below string...
public void connect() { try { string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestDB.mdb;Persist Security Info=True;"; oleConn = new OleDbConnection(ConnStr); oleConn.Open(); } catch (Exception ex) { throw ex; } }public DataSet GetData()
{
connect();
adpt = new OleDbDataAdapter("Select * From Registration", oleConn);
dset = new DataSet();
dset.Clear();
adpt.Fill(dset, "Registration");
if (oleConn.State == ConnectionState.Open)
{
oleConn.Close();
}
return dset;
}
Subhash
Please, Mark as Answer if this reply helped you.