如题,是否有一个代码可以知道总数据量。就好像listbox控件中的listcount属性。
还有看如下代码:
Private Sub Timer1_Timer()
sql = "select top 1 * from word order by rnd(id)"
rs.CursorType = adOpenKeyset
rs.CursorLocation = adUseClient
rs.Open sql, conn
Lblmove(x) = rs(1)
x = x + 1
rs.close
label2.caption = Lblmove(x)
End Sub
------------------------------------------------------------------------
在数据库中有四条数据顺id键递增rs(1)分别="猫","狗","你好","好"
上面我用order by rnd 随机方法的sql读取数据,每次都是以一定的顺序读取,就好像
"你好","好","猫","狗"的顺序,可否每次都是不同的顺序?而且当读完这四条数据
后,可否自动停止读取数据,即timer1.enabled = false
还有看如下代码:
Private Sub Timer1_Timer()
sql = "select top 1 * from word order by rnd(id)"
rs.CursorType = adOpenKeyset
rs.CursorLocation = adUseClient
rs.Open sql, conn
Lblmove(x) = rs(1)
x = x + 1
rs.close
label2.caption = Lblmove(x)
End Sub
------------------------------------------------------------------------
在数据库中有四条数据顺id键递增rs(1)分别="猫","狗","你好","好"
上面我用order by rnd 随机方法的sql读取数据,每次都是以一定的顺序读取,就好像
"你好","好","猫","狗"的顺序,可否每次都是不同的顺序?而且当读完这四条数据
后,可否自动停止读取数据,即timer1.enabled = false
2. sql = "select top 4 * from word order by rnd(id)" 提取前4条记录
order by rnd这个语句就非常不明白你的意思了
随机排序 select * from Table Order by NEWID
select count(id) from word 得到
至于随机读记录,是用什么数据库????如果是sql server 可以用:
select top 1 * from word order by newid()
实现。。
================
bug。。
把连接的CursorLocation设为adUseClient(不是rs记录集)。。