Getting A Query List

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I"m addressing Access from an external application and need to get a list of
all queries in the database using C # and return the value list back to my
application where I will use it to populate a GUI control. Does anyone have
any suggestions, or if this is not the right newsgroup, point me to one that
is better suited for my question?

Dan
 
The following sample returns a list of tables in a database.
public DataTable GetTables(OleDbConnection conn)
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null,
null, "TABLE"});
conn.Close();
return schemaTable;
}
I would guess thsi can be adapted to get queries."Dan"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top