我这样还不行啊:Dim oConn As New ADODB.Connection Dim oRs As New ADODB.Recordset Dim strConnStr As String Dim strDBPath As String Dim strSQL As String Private Sub Form_Load() strDBPath = App.Path & IIf(Right(App.Path, 1) = "\", "products.mdb", "\products.mdb") strConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath strSQL = "select * from products"
oConn.ConnectionString = strConnStr oConn.Open
oRs.Open strSQL, oConn, adOpenStatic MsgBox oRs.RecordCount '显示为19 Set DataGrid1.DataSource = oRs DataGrid1.Refresh End Sub
Dim oRs As New ADODB.Recordset
Dim strConnStr As String
Dim strDBPath As String
Dim strSQL As String
Private Sub Form_Load()
strDBPath = App.Path & IIf(Right(App.Path, 1) = "\", "products.mdb", "\products.mdb")
strConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath
strSQL = "select * from products"
oConn.ConnectionString = strConnStr
oConn.Open
oRs.Open strSQL, oConn, adOpenStatic
MsgBox oRs.RecordCount '显示为19
Set DataGrid1.DataSource = oRs
DataGrid1.Refresh
End Sub
oconn.CursorLocation = adUseClient