利用OleDb的GetOLEDBSchemaTable方法得到数据库架构信息
新客网 XKER.COM 2004-11-03 来源： 收藏本文
我们可以利用OleDb的GetOLEDBSchemaTable方法得到数据库的所有视图，表，存储过程等信息。
GetDataBaseSchema.aspx
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="GetDataBaseSchema.aspx.vb"
Inherits="aspxWeb.GetDataBaseSchema"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>GetDataBaseSchama</title>
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="DataGrid2" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="DataGrid3" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="DataGrid4" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="Datagrid5" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="Datagrid6" runat="server"></asp:DataGrid>
</form>
</body>
</HTML>
GetDataBaseSchema.aspx.vb
Imports System
Imports System.Data
Imports System.Data.OleDb
Public Class GetDataBaseSchema
Inherits System.Web.UI.Page
Protected WithEvents DataGrid2 As System.Web.UI.WebControls.DataGrid
Protected WithEvents DataGrid3 As System.Web.UI.WebControls.DataGrid
Protected WithEvents DataGrid4 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Datagrid5 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Datagrid6 As System.Web.UI.WebControls.DataGrid
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
#Region " Web Form Designer Generated Code "
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.Init
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.Load
'如何得到数据库中的架构信息？
'GetOLEDBSchemaTable函数有两个方法：
'OLEDBSchemaGUID
'Restrictions
'参数OLEDBSchemaGUID 的成员：Tables, Procedures, Views, Columns, Catlogs 等
'参数restrictions为限制条件，是一个对象数组，原来过虑架构结果信息，
'每一个对象映射到所返回的datacolumn的值。
Dim strCnn As String
strCnn = "Provider=SqlOLEDB; Data Source=.\NetSDK; Initial Catalog=pubs;User ID=sa;Password=;"
Dim dataConn As New OleDbConnection(strCnn)
Try
dataConn.Open()
Dim schemaTable As DataTable
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
'得到全部的表、视图
DataGrid1.DataSource = schemaTable
DataGrid1.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
'得到全部的用户表,用户表类型为Table，进行过虑
DataGrid2.DataSource = schemaTable
DataGrid2.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "VIEW"})
'得到全部的视图
DataGrid3.DataSource = schemaTable
DataGrid3.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Procedures, Nothing)
'得到全部的存储过程
DataGrid4.DataSource = schemaTable
DataGrid4.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Provider_Types, Nothing)
'得到全部支持的数据类型
Datagrid5.DataSource = schemaTable
Datagrid5.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Primary_Keys, Nothing)
Datagrid6.DataSource = schemaTable
Datagrid6.DataBind()
Catch ex As Exception
Response.Write(ex.Message.ToString())
Finally
dataConn.Close()
End Try
End Sub
End Class
GetDataBaseSchema.aspx
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="GetDataBaseSchema.aspx.vb"
Inherits="aspxWeb.GetDataBaseSchema"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>GetDataBaseSchama</title>
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="DataGrid2" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="DataGrid3" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="DataGrid4" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="Datagrid5" runat="server"></asp:DataGrid><br>
<asp:DataGrid id="Datagrid6" runat="server"></asp:DataGrid>
</form>
</body>
</HTML>
GetDataBaseSchema.aspx.vb
Imports System
Imports System.Data
Imports System.Data.OleDb
Public Class GetDataBaseSchema
Inherits System.Web.UI.Page
Protected WithEvents DataGrid2 As System.Web.UI.WebControls.DataGrid
Protected WithEvents DataGrid3 As System.Web.UI.WebControls.DataGrid
Protected WithEvents DataGrid4 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Datagrid5 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Datagrid6 As System.Web.UI.WebControls.DataGrid
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
#Region " Web Form Designer Generated Code "
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.Init
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.Load
'如何得到数据库中的架构信息？
'GetOLEDBSchemaTable函数有两个方法：
'OLEDBSchemaGUID
'Restrictions
'参数OLEDBSchemaGUID 的成员：Tables, Procedures, Views, Columns, Catlogs 等
'参数restrictions为限制条件，是一个对象数组，原来过虑架构结果信息，
'每一个对象映射到所返回的datacolumn的值。
Dim strCnn As String
strCnn = "Provider=SqlOLEDB; Data Source=.\NetSDK; Initial Catalog=pubs;User ID=sa;Password=;"
Dim dataConn As New OleDbConnection(strCnn)
Try
dataConn.Open()
Dim schemaTable As DataTable
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
'得到全部的表、视图
DataGrid1.DataSource = schemaTable
DataGrid1.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
'得到全部的用户表,用户表类型为Table，进行过虑
DataGrid2.DataSource = schemaTable
DataGrid2.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "VIEW"})
'得到全部的视图
DataGrid3.DataSource = schemaTable
DataGrid3.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Procedures, Nothing)
'得到全部的存储过程
DataGrid4.DataSource = schemaTable
DataGrid4.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Provider_Types, Nothing)
'得到全部支持的数据类型
Datagrid5.DataSource = schemaTable
Datagrid5.DataBind()
schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Primary_Keys, Nothing)
Datagrid6.DataSource = schemaTable
Datagrid6.DataBind()
Catch ex As Exception
Response.Write(ex.Message.ToString())
Finally
dataConn.Close()
End Try
End Sub
End Class
最新相关文章- ·身份证函数 查看身份证地区信息
- ·VS2008 第一次安装心得及使用
- ·ASP.NET 2.0跨网页提交的三法
- ·编程实例 WebGroupBox(Aspx控件)
- ·asp.net mvc脚手架代码生成工具
- ·用独立的DLL来存储图片(资源文件)
- ·ASP.NET中多国语言的实现方法
- ·实例 .net生成静态页方法总结
- ·ASP.NET控件学习笔记之ViewState
- ·用递归在TreeView价节点
- ·经验总结 关于.NET 中的Event机制
- ·.NET应用程序开发标准化(z)
- ·在DataTable中查询应该注意的问题
- ·LINQ 中调用存储过程自动绑定列名
- ·如何用.NET技术在线生成网站LOGO
- ·对于访问IIS元数据库失败的解决
发表评论
评论内容：不能超过250字，需审核后才会公布，请自觉遵守互联网相关政策法规。
阅读排行
- Asp.net Ajax 中的脚本错误: Sys未定义 的解决方
- 身份证号码15位升18位(C#)
- asp.net ajax学习系列功能强大的UpdatePanel控件
- Web Service描述语言 WSDL 详解(1)--为什么使用WS
- Asp.Net Unleashed 2nd Edition 学习笔记 第三部
- UpdatePanel与UrlRewrite
- DataGridView 的分页处理
- 从资源文件里加载文件（C#）
- Javascript与asp.net 实现Ajax多文件无刷新上传
- 关于ASP.NET调用JavaScript的实现
- asp.net面试试题收集
- 基于ASP.NET AJAX的WebPart开发与部署
- Huffman 编码简介（讲解的更好一些，有C的分析）
- 在VC++应用程序中读取文本数据
- 技巧 .NET如何访问MySQL数据库
随机推荐
- 使用C#编程将websphere MQ 5.3 windows客户端消息
- sniffer技术原理及应用,包括编程方法和工具使用（
- 使ACCESS数据库保持同步
- XP下Asp.net访问被拒绝
- 转业界评说：DotNet的进一步消息
- 设计模式之工厂方法（FACTORY METHOD））（三）
- 使用C＃获得系统信息
- "关机/休眠/重启/注销"的类
- 利用数据集在水晶报表中显示图像的 .NET 程序教程
- Wrox的C#高级编程第三版第一部分第一章
- 用api实现数据库的操作！
- 管理 ASP.NET DataGrid 数据列
- 数据装载工具(ETL)设计(Extract Transform Load)
- .net 开发人员应必须拥有的10个工具
- 初学VB.NET连接SQL数据库！
实用信息推荐