本人需要一段用存储过程实现的原代码。
[email protected]
[email protected]
解决方案 »
- datagrid内容写入数据库报错
- 设置电脑分辨率
- 100分悬赏:动态添加自定义控件后,控件的方法和属性都可以正常使用,但是控件的自定义事件却无法触发?急死了!!!
- 请指教小问题,MSFlexGrid如何设定某一列内的字体排列(如:向左,向右)
- 急急急急急急,一个VB的简单问题,请各位大侠帮忙
- 想学习VB的人注意了!(只限制在大连地区)
- 请教用wise installation打包后碰到的运行错误问题?急!!
- 菜鸟问题!
- 请教一个关于日期使用的问题
- vb的问题请教阿
- 想用ACTIVEBAR做一个类式OUTLOOK一样的界面,但是ACTIVEBAR自己带的几个程序上没有例子
- 如何让VB根据实际运行的机器环境自动调用Excel2K或Excel XP
as
begin
select @name=customername from customers where customerid= @id
End
Dim cmd As ADODB.Command
Dim par1 As ADODB.Parameter
Dim par2 As ADODB.Parameter
Set cmd = New ADODB.Command
cmd.CommandText = "test"
cmd.CommandType = adCmdStoredProc
Set par1 = cmd.CreateParameter("a", adInteger, adParamInput, , 3)
cmd.Parameters.Append par1
Set par2 = cmd.CreateParameter("b", adVarChar, adParamOutput, 20)
cmd.Parameters.Append par2
Set cmd.ActiveConnection = cnDatabase
cmd.Execute
Debug.Print par2.Value
Set cmd = Nothing
@Parmk char(10)
AS
select * from 人员基本情况表 Where 姓名=@Parmk
RETURN
GO
Dim Conn As ADODB.Connection
Dim Rs As ADODB.Recordset
Dim Comm As ADODB.CommandPrivate Sub Form_Load()
Set Conn = New ADODB.Connection
Set Rs = New ADODB.Recordset
Set Comm = New ADODB.Command
Conn.ConnectionString = "Provider=SQLOLEDB.1;Password=nndk;Persist Security Info=True;User ID=sa;Initial Catalog=PDoctor;Data Source=ZHD\ZHD"
Conn.Open
Comm.ActiveConnection = Conn
Comm.CommandType = adCmdStoredProc
Comm.CommandText = "sp_vb1"
Comm.Parameters.Refresh
Comm.Parameters("@Parmk").Value = "书剑狂生"
Rs.CursorLocation = adUseClient
Rs.CursorType = adOpenStatic
Rs.LockType = adLockReadOnly
Rs.Open Comm
Set DataGrid1.DataSource = Rs
End Sub
SumColumn As String, Other As String,
TableName As String, Optional ZeroColumn As String = "",
Optional SecondColumn As String = "",
Optional EmptyValue As String = "0")
Dim rs As New ADODB.Recordset
Dim param As ADODB.Parameter
Dim Cmd As New Command
Cmd.ActiveConnection = db 'db 是连接字符串
Cmd.CommandText = "MyCrossTable" ‘ 存储过程名称
Cmd.CommandType = adCmdStoredProc
1 Set param = Cmd.CreateParameter("a", adBSTR, adParamInput, 30,
FirstColumn)
2 Cmd.Parameters.Append param
3 Set param = Cmd.CreateParameter("b", adBSTR, adParamInput, 30,
NewColumn)
4 Cmd.Parameters.Append param 5 Set param = Cmd.CreateParameter("c", adBSTR, adParamInput, 30,
SumColumn)
6 Cmd.Parameters.Append param 7 Set param = Cmd.CreateParameter("d", adBSTR, adParamInput, 300,
Other)
8 Cmd.Parameters.Append param 9 Set param = Cmd.CreateParameter("e", adBSTR, adParamInput, 30,
TableName)
10 Cmd.Parameters.Append param 11 Set param = Cmd.CreateParameter("f", adBSTR, adParamInput, 30,
ZeroColumn)
12 Cmd.Parameters.Append param 13 Set param = Cmd.CreateParameter("g", adBSTR, adParamInput, 30,
SecondColumn)
14 Cmd.Parameters.Append param 15 Set param = Cmd.CreateParameter("h", adBSTR, adParamInput, 30,
EmptyValue)
16 Cmd.Parameters.Append param
17 Set rs = Cmd.Execute
rs.Close
Set rs = Nothing