how to access the queries made and stored in MS Access thru C# Code?

[b. hotting]

hi,

Does anybody know how to access the queries made and stored in MS Access
thru C# Code.

thanks,
bjorn

[billmiami2]

Yes. You will need to use classes in namespaces

System.Data
System.Data.OleDb

A quick example of a function that returns a dataset might be
(unchecked)

--------------------------------
using System.Data;
using System.Data.OleDb;

public class MyClass
{
string strConnect = "enter your OLEDB connection string here";

public static DataSet ExecuteDataset(string strSQL)
{
try
{
//create a command and prepare it for execution
OleDbConnection objConn = new OleDbConnection(strConnect);
OleDbDataAdapter objAdapt = new OleDbDataAdapter(strSQL, objConn);

//Fill the dataset
DataSet DS = new DataSet();
objAdapt.Fill(DS, "DataTable");
return DS;
}

catch (Exception ex)
{
//return nothing if an error has occurred
return null;
}

}
}
---------------------------------
to use the function, you might do the following:

DataSet objDS = myproject.MyClass.ExecuteDataset("SELECT * FROM
qryMySavedQuery");
---------------------------------

There's a lot to learn in.NET so I'm not going to try to show you
everything here. If you're not familiar with .NET, you will probably
want to buy yourself a book and learn about it, especially the data
access portion (System.Data, otherwise known as ADO.NET) of the
framework.

Bill E.
Hollywood, FL