Access数据库的连接(ADO.NET)
点击次数:32 次 发布日期:2008-11-27 01:08:56 作者:源代码网
|
Module Module1 Sub Main() " 首先设置对 System.Data.dll 的引用。 Dim objConn As New OleDbConnection _ ("Provider=Microsoft.Jet.OLEDB.4.0;" & _ "User ID=Admin;" & _ "Data Source=C:Northwind.mdb") objConn.Open() Dim objCmd As New OleDbCommand _ ("SELECT * FROM Products", objConn) Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader objDataReader.Read() Console.Write(objDataReader.Item("ProductName") & ", " & _ objDataReader.Item("UnitsInStock")) End Sub End Module 源代码网供稿. |
