vb.net实例代码 连接访问数据库文件(mdb)

发布时间:2020-02-12编辑:脚本学堂
本文分享一例vb.net代码,学习连接访问数据库文件(mdb)的方法,有需要的朋友参考下。

vb.net实例代码之连接访问数据库文件(mdb)。
代码:
 

复制代码 代码示例:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="vb" runat="server">
Sub Page_Load(Sender As Object, E as EventArgs)
  Dim objConnection As OleDbConnection
  Dim objCommand As OleDbDataAdapter
  Dim strConnect As String
  Dim strCommand As String
  Dim DataSet1 As New DataSet

  strConnect =  "Provider=Microsoft.Jet.OLEDB.4.0;"
  strConnect += "Data Source=yourDatabase.mdb;"
  strConnect += "Persist Security Info=False"

  strCommand = "SELECT ProductName, UnitPrice FROM products"
  objConnection = New OleDbConnection(strConnect)
  objCommand = New OleDbDataAdapter(strCommand, objConnection)
  objCommand.Fill(DataSet1, "products")
  DataGrid1.DataSource=DataSet1.Tables("Products").DefaultView
  DataGrid1.DataBind()
End Sub
</script>
<html>
<head>
<title>Data Grid Control控件的例子-www.jb200.com</title>
</head>
<body>
<asp:DataGrid id="DataGrid1" runat="server"  />
</body>
</html>