如何在mshflexgrid中显示出数据库中的表“aaa”急啊！帮帮忙！

[yelang1210]

在线等，要用到Adodc控件与数据库连接吗？

[titan90]

可以这么做

[yelang1210]

用到adodc控件与数据库连接就是绑定吗？

[射天狼]

首先你要确定下来用什么方式连接数据库(推荐用ADO)

工程->引用->Microsoft Activex Data Objects 2.0 Library( 后面为版本号)

dim cn as new ADODB.connection
dim rs as new ADODB.recordset

cn.connectionstring = ""
cn.open

rs.open "SELECT * FROM TABLENAME",cn

while not rs.eof

'在此向表格中添加数据

rs.next
wend

http://www.connectionstrings.com/
'上这里查询连接字符串!

[射天狼]

不推荐用绑定做,手写代码比较灵活!!

MSFlexGrid1.Rows = 10: MSFlexGrid1.Cols = 5

For i = 1 To MSFlexGrid1.Rows - 1
MSFlexGrid1.TextMatrix(i, 1) = "aaaa" & i
Next

[yoki]

'工程->引用->Microsoft Activex Data Objects 2.0 Library( 后面为版本号)

dim cn as new ADODB.connection
dim rs as new ADODB.recordset

cn.Open "Provider=SQLOLEDB;Data Source=servername;User Id=sa;PassWord=*****;Initial Catalog=testDB"
rs.open "SELECT * FROM aaa",cn
set mshflexgrid1.datasource=rs
rs.close
set rs=nothing
cn.close
set cn=nothing

[yelang1210]

dim cn as new ADODB.connection
dim rs as new ADODB.recordset

cn.connectionstring = ""
cn.open

rs.open "SELECT * FROM TABLENAME",cn

while not rs.eof

'在此向表格中添加数据

rs.next
wend
这些代码该写在什么事件中啊？
我刚学vb的：（

[yelang1210]

//yoki(小马哥--鬓微霜，又何妨)
cn.Open "Provider=SQLOLEDB;Data Source=servername;User Id=sa;PassWord=*****;Initial Catalog=testDB"
这句话什么意思啊？