一个datagrid的显示问题？？？（急）
以下代码在运行时，datagrid控件不显示tablename表中的数据，也不报错，
谋求怎么解决？（谢谢）
***************************************
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=databasename"
rs.open "select * from tablename",cn
set datagrid.datasource=rs
问题点数：0、回复次数：7Top
1 楼efsnake（八蛇）回复于 2003-11-02 12:03:48 得分 0
好像datasource属性必须静态设置。你可以试试用MSHFlexFrid控件！Top
2 楼cryptonym（想裸睡）回复于 2003-11-02 12:49:56 得分 0
rs.open "select * from tablename",cn,adcmdTextTop
3 楼callzjy2（）回复于 2003-11-02 14:16:43 得分 0
cn.CursorLocation = adUseClientTop
4 楼sunnycai（飞鸟）回复于 2003-11-09 01:24:49 得分 0
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=databasename"
rs.CursorLocation = adUseClient '加上这一句
rs.open "select * from tablename",cn
set datagrid.datasource=rs
Top
5 楼neo40（企鹅）回复于 2003-11-09 17:35:25 得分 0
Dim ss As New ADODB.Connection
Dim rs As New ADODB.Recordset
ss.ConnectionString = "Provider=SQLOLEDB;Data Source=servername;User Id=sa;PassWord=****;Initial Catalog=databasename"
ss.Open
rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
rs.LockType = adLockPessimistic
rs.Open "select * from tablename", ss
Set Datagrid.DataSource=rs
Top
6 楼FESPro（yuking）回复于 2003-11-11 15:16:53 得分 0
他们说的使你能得出结果了吗？谢谢Top
7 楼strongfisher（Haiwolf）回复于 2003-11-11 15:23:32 得分 0
cn.CursorLocation = adUseClient
Top
