How to retrieve an Ms Access table using ASP.NET-C# wch should get open in Ms Access

Reitha G Nair's Avatar, Join Date: May 2010
Newbie Member
please Help,
I hav created one web form using ASP.NET-C# and database Mhe s Access 2007. I did save my database in .mdb format.
i want to open a particular table from the database in a button click. The codes i have written s working fine to open the complete database

protectedvoid btnOk_Click(object sender, EventArgs e)
{
Process mProcess = newProcess();
mProcess.StartInfo.FileName =
"D:\\Trade Enquiry Management System\\App_Data\\TenderEnquiryManagementSystem.md b";
mProcess.StartInfo.WindowStyle =
ProcessWindowStyle.Normal;
mProcess.StartInfo.CreateNoWindow =
true;
mProcess.Start();
mProcess.WaitForExit();
if (!mProcess.HasExited)
{
mProcess.Kill();
}
mProcess.Close();
}


Bt i want to open a table 'Enquiry' under TenderEnquiryManagementSystem.mdb
Any body ll pls help me to get the code for that?????

Thanq
Reitha
0
satyedra pal's Avatar, Join Date: Mar 2010
Contributor
MSAccess table can be access in ASP.Net also by using oledb database provider.Oledb is used on the place of process with its coding.