利用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();

posted on 2004-07-08 13:02  lee  阅读(567)  评论(0编辑  收藏  举报

导航