Getting A Query List

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
 
J

JohnFol

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"
 
Top