VB绑定给datagrid的小疑点！很简单只是小弟我是菜鸟！

VB绑定给datagrid的小问题！！很简单只是我是初学者！！
我想把检索出来的内容绑定给datagrid1,但是现在有问题，语句如下：

VB code

Private Sub Command1_Click()Dim strsql As StringDim con As ADODB.ConnectionDim cmd As ADODB.CommandDim rs As ADODB.RecordsetSet con = New ADODB.ConnectionSet cmd = New ADODB.CommandSet rs = New ADODB.Recordsetstrsql = "server=.;database=DB;uid=sa;pwd=123"con.ConnectionString = strsqlcon.Provider = "SQLOLEDB"con.Opencmd.CommandText = "select * from yh"cmd.ActiveConnection = conSet rs = con.Execute(cmd.CommandText, n)Set DataGrid1.DataSource = rsEnd Sub

现在提示上面这句‘行集合不能作为标签’，请帮忙解决！谢谢！

[解决办法]
加一句
rs.CursorLocation = adUseClient

查看更多 下一篇