to lihonggen0(李洪根,用.NET,标准答案来了):
我试了一下你的,能用
下面是我的代码,为什么不行
定义:
Dim sql As String
Dim conndb As New ADODB.Connection
Dim cmddb As New ADODB.Command
Dim rsdb As New ADODB.Recordset
。。。。。。。。
conndb.CursorLocation = adUseClient
conndb.Open contextDB
cmddb.ActiveConnection = conndb
cmddb.CommandText = sql
Set rsdb = cmddb.Execute
然后
Set DataGrid1.DataSource = rsdb
Private Sub Command1_Click()
DataGrid1.Row = 3
DataGrid1.Columns(2).Text = "safsdfsd"
End Sub
Private Sub Form_Load()
'工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号)
Dim CN As New ADODB.Connection '定义数据库的连接
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
Private Sub Command1_Click()
DataGrid1.Row = 3
DataGrid1.Columns(2).Text = "safsdfsd"
End Sub
Private Sub Form_Load()
'工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号)
Dim CN As New ADODB.Connection '定义数据库的连接
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"