MSHFlexGrid 为何只显示一行数据

[angelleecash]

我 MSHFlexGrid 显示数据库查询结果
其中display是窗体中的一个MSHFlexGrid控件
我的步骤是
dim con as new ADODB.Connection
dim rs as new ADODB.RecordSet
con.ConntionString = ""
con.open
set rs = con.execute("select * from test")
set display.DataSource = rs

查询出来的结果是多行,但是在该控件中却只能显示一行,请大家帮忙

[饮水需思源]

dim con as new ADODB.Connection
dim rs as new ADODB.RecordSet
con.ConntionString = "..."
con.open
if rs.state=adstateopen then rs.close
rs.open "select * from test",con,adopenkeyset,adlockreadonly
set display.DataSource = rs
rs.close
set rs=nothing

[angelleecash]

谢谢,我的问题解决了,可是能解释一下为什么吗