-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: NKR
Message 3 in Discussion
Hi Deep,<o:p></o:p>
Declare a Command object<o:p></o:p>
Dim lcmdCreateJob as adodb.command<o:p></o:p>
Dim
lcon as adodb.connection<o:p></o:p>
lcmdCreateJob.ActiveConnection
= lcon<o:p></o:p>
lcmdCreateJob.CommandType
= adCmdStoredProc<o:p></o:p>
lcmdCreateJob.CommandText
= "PRC_CREATE_JOB"(This is procedure name)<o:p></o:p>
with
lcmdCreateJob<o:p></o:p>
.Parameters.Append
.CreateParameter ("ipstrTJOBInsert", adVarChar, adParamInput, 2000,
lstrInsertSt)<o:p></o:p>
.Parameters.Append .CreateParameter ("opstrHUBINSERT",
adVarChar, adParamOutput, 2000, lstrHubContract)<o:p></o:p>
end
with<o:p></o:p>
lcmdCreateJob.execute<o:p></o:p>
<o:p> </o:p>
here ipstrTJOBInsert is the
input parameter name like the one in SP and lstrInsertSt is value which u pass
from VB<o:p></o:p>
here opstrHUBINSERT is the output
parameter name like the one in SP and lstrHubContract is value which u want to
get from SP to VB<o:p></o:p>
<o:p> </o:p>
regards<o:p></o:p>
Rajesh<o:p></o:p>
From: haideep
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 2:59
PM
To: BDOTNET
Subject: Calling stored procedure
in Visual Basic<o:p></o:p>
<o:p> </o:p>
<o:p></o:p>
<o:p></o:p>
New
Message on BDOTNET<o:p></o:p>
<o:p></o:p>
<o:p> </o:p>
Calling stored
procedure in Visual Basic<o:p></o:p>
Reply
<o:p></o:p>
<o:p></o:p>
Reply to Sender Recommend
<o:p></o:p>
Message 1 in
Discussion <o:p></o:p>
<o:p></o:p>
From: haideep <o:p></o:p>
<o:p> </o:p>
Hi folks,<o:p></o:p>
<o:p></o:p>
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).<o:p></o:p>
<o:p></o:p>
If possible pl. send me the syntax.<o:p></o:p>
<o:p></o:p>
Thanks<o:p></o:p>
<o:p></o:p>
Regards,<o:p></o:p>
deep<o:p></o:p>
<o:p></o:p>
View other groups in this
category.
language="JavaScript" type="text/javascript">
document.write('');
</script>
-----------------------------------------------------------
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]
