1>.加入参考(引用) .NET中 ADODB.dll
Public cnn As ADODB.Connection
Private Sub cmdOpen_Click(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles cmdOpen.Click
Dim MyPath As String = "D:\db1.mdb"
cnn.Provider = "MSDataShape"
cnn.ConnectionString = "Data Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & MyPath & ";Persist Security Info=False;"
cnn.Open()
Dim rs As New ADODB.Recordset
rs.Open("Select * from reports", cnn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic)
Dim da As New System.Data.OleDb.OleDbDataAdapter()
Dim ds As New DataSet()
da.Fill(ds, rs, "reports")
Me.TextBox1.Text = ds.Tables(0).Rows.Count.ToString
DataGridView1.DataSource = ds.Tables(0)
cnn.Close()
End Sub
2>.vb6的基础知识部分可以用的上,但大多数语法是不同的.visual studio 2005最好还是用visual studio 2005的书籍.
温馨提示:内容为网友见解,仅供参考