-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: sachingpatel
Message 2 in Discussion
Set l_cmd = New ADODB.Command
l_cmd.CommandText = "USP_UpdateScore"
l_cmd.CommandType =
adCmdStoredProc
l_cmd.Parameters.Append l_cmd.CreateParameter("RetValue", adInteger,
adParamReturnValue)
l_cmd.Parameters.Append
l_cmd.CreateParameter("sExamTitle", adVarChar, adParamInput, 64,
m_strExamTitle)
l_cmd.Parameters.Append
l_cmd.CreateParameter("sExamineeId", adVarChar, adParamInput, 64,
strExamineeId)
l_cmd.Parameters.Append
l_cmd.CreateParameter("iScore", adInteger, adParamInput, ,
iScore)
l_cmd.Parameters.Append
l_cmd.CreateParameter("iExamResult", adInteger, adParamInput, ,
iExamResult)
l_cmd.Parameters.Append
l_cmd.CreateParameter("bIsScoreSysComputed", adBoolean, adParamInput, ,
bIsScoreSysComputed)
l_cmd.Parameters.Append
l_cmd.CreateParameter("ExamStatus", adInteger, adParamInput, ,
iExamStatus)
l_cmd.Parameters.Append
l_cmd.CreateParameter("ScoreComputedBy", adVarChar, adParamInput, 64,
strExaminerName)
l_cmd.ActiveConnection = m_ConnectString
l_cmd.Execute
UpdateScore =
l_cmd.Parameters("RetValue").Value
Set l_cmd =
Nothing
Sachin Patel
----- Original Message -----
From:
haideep
To: BDOTNET
Sent: Tuesday, May 25, 2004 3:07 PM
Subject: Calling stored procedure in
Visual Basic
New Message on BDOTNET
Calling
stored procedure in Visual Basic
Reply
Reply to Sender Recommend
Message 1 in
Discussion
From: haideep
Hi folks,
can any of you tell me how to call a stored
procedure in Visual Basic (not in dotnet)
and how to pass the parameters to the stored procedure
(SQLServer 2000).
If possible pl. send me the syntax.
Thanks
Regards,
deep
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
