我在程序中调用一个存储过程,想将存储过程中的SELECT记录集结果返回到程序中的DATAGRID,如何做呀。
请高手指教
请高手指教
解决方案 »
- 我设置的com口怎么不起作用呢?
- Recordset.UpdateBatch和Recordset.Update有区别吗?
- 如何将一个已通过OPEN打开的recorderset新加入一个字段呢?
- 新手弱问
- 求 Matthew Curland著 高级 Visual Basic编程一书的配套光盘
- 小弟是个绝对的新手!!!!跪求!!!!跪求!!!!跪求!!!!跪求!!!!跪求!!!!跪求!!一个对大虾们来说绝对简单的问题
- 请教VB中接收VC自定义消息的地址变量(指针)
- 为什么在VBA中下列代码不能通过?
- 怎样用bitblt将屏幕(包括鼠标)都搞到picture控件里?
- 为什么改变不了打印机打印文字的方向呢 ?急
- 请问,winsock控件实现的时候是采用阻塞工作方式和还是非阻塞工作方式?
- 本人正用vb编写一个MIS,有空就唠唠!QQ149534864
set DATAGRID.**=rs
就行了吧
经过了测试Option Explicit
Private mConn As ConnectionPrivate Sub Command1_Click()
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim param As ADODB.Parameter
Set cmd = New ADODB.Command
cmd.ActiveConnection = mConn
cmd.CommandText = "insert_users"
cmd.CommandType = adCmdStoredProc
Set param = cmd.CreateParameter("truename", adChar, adParamInput, 20, Trim(txttruename.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("regname", adChar, adParamInput, 20, Trim(txtregname.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("pwd", adChar, adParamInput, 20, Trim(txtpwd.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("sex", adChar, adParamInput, 20, Trim(txtsex.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("email", adChar, adParamInput, 20, Trim(txtemail.Text))
cmd.Parameters.Append param
Set rs = cmd.Execute
Command2_Click
End SubPrivate Sub Command2_Click()
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim param As ADODB.Parameter
Set rs = New ADODB.Recordset
Set cmd = New ADODB.Command
cmd.ActiveConnection = mConn
cmd.CommandText = "select_users"
cmd.CommandType = adCmdStoredProc
mConn.CursorLocation = adUseClient '设置为客户端 Set rs = cmd.Execute() MsgBox rs.RecordCount
Set DataGrid1.DataSource = rs
DataGrid1.RefreshEnd SubPrivate Sub Form_Load()
'open the connection
Set mConn = New Connection
mConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=TestUser;Data Source=yang"
mConn.Open
Dim rs As New ADODB.Recordset
'Set rs = New ADODB.Recordset
rs.Open "users", mConn, adOpenStatic, adLockPessimistic
MsgBox rs.RecordCountEnd SubPrivate Sub Form_Unload(Cancel As Integer) mConn.Close
Set mConn = Nothing
End Sub
rs.Open "users", mConn, adOpenStatic, adLockPessimistic
这里面的"user"是指什么?
另外,为什么我在
mycommand.CommandType = adCmdStoredProc
mycommand.CommandText = "areaAll"
Set myrst = New ADODB.Recordset
Set myrst = mycommand.Execute()
Debug.Print "exeok!!!!"
Debug.Print myrst.State
MsgBox myrst.RecordCount
Set DataGrid1.DataSource = myrst
DataGrid1.Refresh运行时提示错误,显示:行集合不能作为标签。同时在MSGBOX处显示-1,哪里的问题呢?帮忙啊,谢谢。
这里面的"user"是指什么?
是表运行时提示错误,显示:行集合不能作为标签。同时在MSGBOX处显示-1,哪里的问题呢?帮忙啊,谢谢。
请设置客户端游标
cmd.CommandType = adCmdStoredProc
mConn.CursorLocation = adUseClient '设置为客户端