利用C#得到数据库中的表明
string strconn = @"User ID=sa;Tag with column collation when possible=False;Data Source=JAVA;Password=123456;Initial Catalog=netsecdb_ether_20;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=True;Provider=""SQLOLEDB.1"";Workstation ID=AAA218;Use Encryption for Data=False;Packet Size=4096";
OleDbConnection dataConn = new OleDbConnection(strconn);
dataConn.Open();
DataTable schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
//得到全部的表、视图
DataGrid1.DataSource = schemaTable;
DataGrid1.DataBind();
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[]{null, null, null, "TABLE"});
//得到全部的用户表,用户表类型为Table,进行过虑
DataGrid2.DataSource = schemaTable;
DataGrid2.DataBind();
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[]{null, null, null, "VIEW"});
//得到全部的视图
DataGrid3.DataSource = schemaTable;
DataGrid3.DataBind();
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Procedures, null);
//得到全部的存储过程
DataGrid4.DataSource = schemaTable;
DataGrid4.DataBind();
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Provider_Types, null);
//得到全部支持的数据类型
DataGrid5.DataSource = schemaTable;
DataGrid5.DataBind();
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Primary_Keys, null);
DataGrid6.DataSource = schemaTable;
DataGrid6.DataBind();