下段程序编译时出错!出错信息为找不到datagrid1.source方法或数据类型!为什么?
Private Sub Command1_Click()
Set cmd = New ADODB.Command
cmd.ActiveConnection = db
cmd.CommandText = "select from 学生 where 学号=text1.text"
cmd.CommandType = adCmdStoredProc
cmd.Execute
DataGrid1.DataSource = rst
End Sub
Private Sub Command1_Click()
Set cmd = New ADODB.Command
cmd.ActiveConnection = db
cmd.CommandText = "select from 学生 where 学号=text1.text"
cmd.CommandType = adCmdStoredProc
cmd.Execute
DataGrid1.DataSource = rst
End Sub
cmd.CommandText = "select from 学生 where 学号=" & text1.text
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.Provider = "microsoft.jet.oledb.4.0"
cn.Open "C:\Test.mdb"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select * from 学生 where 学号='" & Text1.Text & "'", cn, adOpenDynamic, adLockOptimisticSet DataGrid1.DataSource = rs
End Sub'必须指定游标类型,详情参见
'http://expert.csdn.net/Expert/topic/2943/2943672.xml?temp=.965008
给对象赋值应该用下面的语句
Set DataGrid1.DataSource = rs