1.获取数据库中所有的表
object[] objArrRestrict;
objArrRestrict = new object[] {null, null, null, "TABLE"};
DataTable schemaTbl = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,objArrRestrict);
objArrRestrict = new object[] {null, null, null, "TABLE"};
DataTable schemaTbl = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,objArrRestrict);
con是OledbConnetion
2.取某个表中所有的column
object[] objArrRestrict;
objArrRestrict = new object[] {null, null, selTbl, null};
DataTable schemaCols = con.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, objArrRestrict);
objArrRestrict = new object[] {null, null, selTbl, null};
DataTable schemaCols = con.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, objArrRestrict);
schemaCols.Rows[0][“COLUMN_NAME”]为column的名字