>I'm trying to get the column names of queries in MS Access . So far I have:
>
>

>public static void Test()
>{
>    OleDbConnection connection = new OleDbConnection(AccessConnString);
>
>    try
>    {
>        connection.Open();
>    }
>    catch (Exception e)
>    {
>        throw e;
>    }
>
>    DataTable t1 = connection.GetSchema("Columns");         // Returns Table column names
>    DataTable t2 = connection.GetSchema("Procedures");      // Returns all Query names
>    DataTable t3 = connection.GetSchema("Views");           // Returns all Subquery names
>
>    connection.Close();
>}
>

>
>I cannot see to figure out how to get the column names for queries/subqueries. Anyone know how to do this?


Assuming you are doing this against Norhwind.mdb:

DataTable t = con.GetSchema("columns",new string[] {null,null,"Sales By Category",null});

Cetin