ASP.Net/ADO.net Database/OleDbSchema

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Discovering Schema Information

   <source lang="csharp">

<%@ Import namespace="System.Data" %> <%@ Import namespace="System.Data.Oledb" %> <html> 

 <head>
   <title> Discovering Schema Information</title>
 </head>
 <body>

Discovering Schema Information

   <asp:DataGrid id="dgSchema" runat="server" />
 </body>

</html> <script language="VB" runat="server"> Sub Page_Load(Source As Object, E As EventArgs) 

 Dim strConnection As String = "provider=Microsoft.Jet.OLEDB.4.0;" & _
                       "data source="+MapPath("EmployeeDatabase.mdb")+";"
 Dim objConnection As New OleDbConnection(strConnection)
 Dim dsSchema As DataSet = New DataSet()
 Dim dtSchema As DataTable
 objConnection.Open()
 dtSchema = objConnection.GetOleDbSchemaTable( _
                       OleDbSchemaGuid.Columns, Nothing)
 dsSchema.Tables.Add(dtSchema)
 dgSchema.DataSource = dsSchema
 dgSchema.DataBind()
 objConnection.Close()

End Sub </script> 

      </source>

<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>

Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/OleDbSchema&oldid=1603»