MSFlexGrid 与数据库相连?? 使用代码连接时可以声明一个ADO对象,然后再打开该对象,在成功的取得数据库,用如下语句就可以:Dim rst as ADO.Recordsetrst.Open""set MSHFlexGrid1.DataSoruce=rst 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用代码实现是个好主意:如下dim conn as new adodb.connection,rs as adodb.recordsetOn Error Resume Next Conn.Open Connstr$ Ssql$ = "select useid,usepwd,usesfen from usetest" Rs.Open Ssql$, Conn, adOpenForwardOnly, adLockReadOnly If Err.Number <> 0 Then MsgBox Err.Description, vbOKOnly + vbExclamation, "error:about": End With MSFlexGrid1 If Rs.EOF Then .Rows = 3 While Not Rs.EOF .Col = 1: .Text = Rs("useid") & "" .Col = 2: .Text = Rs("usepwd") & "" .Col = 3: .Text = Rs("usesfen") & "" .Rows = .Rows + 1 .Row = .Row + 1 Rs.MoveNext Wend .Rows = .Rows - 1 End With let me test . and you will earn your point . thanks a lot!!! 2 man dou you. qiu to ma te! 求助表格控件FlexCell注册码 请教一个关于用VB做程序对zebra斑马标签打印机打印标签的问题谢谢 在Grid中如何加载控件? vb里有没有链表的类? vb6 怎么扩展 window.external 请问给一个表改名?? 如何取得服务器的CPU号或是本机的CPU号? rs.open adOpenDynamic 的风险,高手请进 帮帮忙!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :( 如何call一个dos进程 如何在NT的任务管理器里,隐藏自己的程序? 什么是“分布式应用系统”??
dim conn as new adodb.connection,rs as adodb.recordset
On Error Resume Next
Conn.Open Connstr$
Ssql$ = "select useid,usepwd,usesfen from usetest"
Rs.Open Ssql$, Conn, adOpenForwardOnly, adLockReadOnly
If Err.Number <> 0 Then MsgBox Err.Description, vbOKOnly + vbExclamation, "error:about": End
With MSFlexGrid1
If Rs.EOF Then .Rows = 3
While Not Rs.EOF
.Col = 1: .Text = Rs("useid") & ""
.Col = 2: .Text = Rs("usepwd") & ""
.Col = 3: .Text = Rs("usesfen") & ""
.Rows = .Rows + 1
.Row = .Row + 1
Rs.MoveNext
Wend
.Rows = .Rows - 1
End With
qiu to ma te!