数据库:master 表:userinfo 字段:userid,username,password
窗体里msflexgrid1,command1两个控件..
目的:单击command1,在msflexgrid里显示我查找的信息"select userid,username from userinfo"Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As Stringcn = "Provider=sqloledb;Server=127.0.0.1;Database=master;Uid=sa;" + "Pwd=;"
cn.Open
sql = "select userid,username from userinfo"哪位哥哥帮我写一个,谢谢
窗体里msflexgrid1,command1两个控件..
目的:单击command1,在msflexgrid里显示我查找的信息"select userid,username from userinfo"Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As Stringcn = "Provider=sqloledb;Server=127.0.0.1;Database=master;Uid=sa;" + "Pwd=;"
cn.Open
sql = "select userid,username from userinfo"哪位哥哥帮我写一个,谢谢
Dim rs As New ADODB.Recordset
Dim sql As String cn = "Provider=sqloledb;Server=127.0.0.1;Database=master;Uid=sa;" + "Pwd=;"
cn.Open
sql = "select userid,username from userinfo"
if rs.state<>adstateclosed then rs.close
rs.open sql,cn,adopenkeyset,adlockreadonly
set msflexgrid1.datasource=rs
rs.close
..set msflexgrid1.datasource=rs 这个是错的..本来我也是这样想的..
论坛里好像有说运行时不能设置数据源的..
我要把分给左手哥,WallesCai哥你拿星星出来吓我..嘎嘎