>>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(); >>} >>>>
DataTable t = con.GetSchema("columns",new string[] {null,null,"Sales By Category",null});>Cetin