Private Sub Form_Load()
Dim rsTemp As Recordset
Dim dbTemp As Database
Dim astr As String
Set dbTemp = DBEngine(0).OpenDatabase(App.Path + "\学 生.mdb", dbOpenSnapshot)
astr = "SELECT * FROM 学生; "
Set rsTemp = dbTemp.OpenRecordset(astr) If rsTemp.RecordCount > 0 Then
Label1.Caption = rsTemp.RecordCount
end if
End Sub
rsTemp.RecordCount 获得的值始终为1,为什么,怎么解决??
Dim rsTemp As Recordset
Dim dbTemp As Database
Dim astr As String
Set dbTemp = DBEngine(0).OpenDatabase(App.Path + "\学 生.mdb", dbOpenSnapshot)
astr = "SELECT * FROM 学生; "
Set rsTemp = dbTemp.OpenRecordset(astr) If rsTemp.RecordCount > 0 Then
Label1.Caption = rsTemp.RecordCount
end if
End Sub
rsTemp.RecordCount 获得的值始终为1,为什么,怎么解决??
dim I as interger
...
i=0
do until rsTemp.eof
i=i+1
rsTemp.moveNext
loop
Label1.Caption = rsTemp.RecordCount-1
adodc1.recordset.recordCount
Label1.Caption = rsTemp.RecordCount-1
Label1.Caption = rsTemp.RecordCount
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
path = App.path & "\jxcun.mdb"
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & ";Persist Security Info=False"
db.ConnectionString = connstr
db.Open
rs.Open "select usename from usera", db, adOpenStatic, adLockReadOnly
Dim i As String
For t = 0 To Val(rs.RecordCount) - 1
i = Trim(rs.Fields("usename").Value)
rs.MoveNext
Label1.Caption = rs.RecordCount
Combo1.AddItem i
Next t
rs.Close
db.Close
End Sub也能正常显示呀!
能不能这样试一下!
Label1.Caption = val(rsTemp.RecordCount)
moveprevious
再试试看
Label1.Caption = rsTemp.RecordCount
改成adodc控件了谢谢大家了