object
[] objArrRestrict;
objArrRestrict = new object []
{null, null, null, "TABLE"}
;
DataTable schemaTbl = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,objArrRestrict);
objArrRestrict = new object []
![dot.gif](/Images/dot.gif)
DataTable schemaTbl = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,objArrRestrict);
schemaTbl.Rows[0][“TABLE_NAME”]为table的名字
2.取某个表中所有的column
object
[] objArrRestrict;
objArrRestrict = new object []
{null, null, selTbl, null}
;
DataTable schemaCols = con.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, objArrRestrict);
objArrRestrict = new object []
![dot.gif](/Images/dot.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
DataTable schemaCols = con.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, objArrRestrict);