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.Ole Db

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

--------------------------------
using System.Data;
using System.Data.Ole Db;

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);
OleDbDataAdapte r objAdapt = new OleDbDataAdapte r(strSQL, objConn);

//Fill the dataset
DataSet DS = new DataSet();
objAdapt.Fill(D S, "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.MyCla ss.ExecuteDatas et("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