Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-03 : 07:25:26
|
| catherine writes "i wanted to pass parameters to stored procedure.how do i define the parameters at the code behind page at vb.net so that the stored procedure would get the correct parameters.thanks." |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2003-07-06 : 01:39:17
|
| You will have to decalre a command instantiate it...start adding paramters to the command.parameters collectionDim cmd as New SqlCommandcmd.parameters.add New SqlCommandParamter(...choose your constructer.)Then fill the paramters :cmd.paramters("@Param1").value = "bla bla bla"cmd.paramters("@Param2").value = "bom bom bom"etc...then u execute cmd as U wish!HTH |
 |
|
|
|
|
|
call & pass parameters to stored procedure in vb.net