OleDbSchemaGuid的应用

最新推荐文章于 2021-12-21 13:48:24 发布

asthlon

最新推荐文章于 2021-12-21 13:48:24 发布

阅读量2.6k

点赞数

分类专栏： ASP.NET 文章标签： table sql server object schema 数据库 join

本文链接：https://blog.youkuaiyun.com/asthlon/article/details/745310

版权

ASP.NET 专栏收录该内容

54 篇文章

订阅专栏

本文介绍了一种使用SQL和OleDb连接来获取SQL Server和Access数据库表结构的方法，并提供了一个简单的示例来展示如何通过OleDbSchemaGuid来获取表、列和类型的信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

   string ConStr;
   ConStr = "Provider=SQLOLEDB;data source=127.0.0.1;uid=sa;pwd=;database=KWDataBase";
   DataTable STable;
   DataTable SDTable;
   DataTable SFTypeTable;
   OleDbConnection OleDbCon = new OleDbConnection();
   OleDbCon.ConnectionString = ConStr;
   OleDbCon.Open();
   OleDbCommand OleDbCmd = new OleDbCommand(Sql,OleDbCon);
   //Object[]{"TABLE_CATALOG","TABLE_SCHEMA","TABLE_NAME","TABLE_TYPE"}
   STable = OleDbCon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new Object[]{"KWDataBase","dbo","member",null});
   //Object[]{"TABLE_CATALOG","TABLE_SCHEMA","TABLE_NAME","COLUMN_NAME"}
   SDTable = OleDbCon.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,new Object[]{"KWDataBase","dbo","member",null});
   SFTypeTable = OleDbCon.GetOleDbSchemaTable(OleDbSchemaGuid.Provider_Types,new Object[]{});
   this.DataGrid1.DataSource = STable;
   this.DataGrid1.DataBind();
   this.DataGrid2.DataSource = SDTable;
   this.DataGrid2.DataBind();
   this.DataGrid3.DataSource = SFTypeTable;
   this.DataGrid3.DataBind();
   OleDbCon.Close();
Sql Server 取数据库结构不用向以上方法哪样麻烦,只用一条 SQL 语句就可以了

"select c.Name,b.name,a.* from dbo.syscolumns a
inner join dbo.sysobjects b on a.ID=b.ID
inner join dbo.systypes c on a.XTYPE=c.XTYPE
where b.xtype='U'"

但如果取 Access 数据库表结构也只能用OleDbSchemaGuid了