Dim conn As New ADODB.connection
Dim rs As New ADODB.Recordset
Dim str As String
Dim intdb As Integer
conn.CursorLocation = adUseClient
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Data Source=" & App.Path & "\school.mdb;Persist Security Info=False"
Set rs = conn.Execute("select * from news")
fg.Rows = 0
fg.Rows = 2
fg.FixedRows = 1
Set fg.DataSource = rs
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
Dim rs As New ADODB.Recordset
Dim str As String
Dim intdb As Integer
conn.CursorLocation = adUseClient
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Data Source=" & App.Path & "\school.mdb;Persist Security Info=False"
Set rs = conn.Execute("select * from news")
fg.Rows = 0
fg.Rows = 2
fg.FixedRows = 1
Set fg.DataSource = rs
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
这个正确
楼主对比一下
if not rs.eof then
Set fg.DataSource = rs
end if
Option Explicit
Dim conn As adodb.Connection
Dim rs As adodb.Recordset
fg.Rows = 0
fg.Rows = 2
fg.FixedRows = 1不知这块程序是在类,还是Form 中??
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Data Source=" & App.Path & "\school.mdb;Persist Security Info=False"
rs.open "select * from news",conn,adopenkeyset,adlockreadonly
Set fg.DataSource = rs