adding parameters

  • Thread starter Thread starter tshad
  • Start date Start date
T

tshad

When I normally set up my Sql statements and parameters, I would normally
do:

Dim objCmd as New SqlCommand("AddNewResumeCoverTemplate",objConn)
objCmd.CommandType = CommandType.StoredProcedure
objCmd.parameters.add("@ClientID",SqldbType.VarChar,20).value =
session("ClientID")
objCmd.parameters.add("@Email",SqlDbType.VarChar,45).value =
session("Email")

I am setting up a class where I pass it the parameters and have seen it set
up like:

Dim parameters As SqlParameter () = { _
New SqlParameter("@ClientID",SqlDbType,varChar20), _
New SqlParameter("@Email",SqlDbType.varChar,45)}

parameters(0).value = session("ClientID")
parameters(1).value = session("Email")

Can I combine the 2, similar to the top as something like:

Dim parameters As SqlParameter () = { _
New SqlParameter("@ClientID",SqlDbType,varChar20).value =
Session("ClientID"), _
New SqlParameter("@Email",SqlDbType.varChar,45).value = Session("Email")}

Thanks,

Tom
 
Ben said:
There are two sql parameter overloads that accept a value in the
constructor.

http://msdn.microsoft.com/library/d...entSqlParameterClassctorTopic2.asp?frame=true

http://msdn.microsoft.com/library/d...entSqlParameterClassctorTopic6.asp?frame=true
Click to expand...

So there is no way to do it in one easy command?

The examples are showing you setting up one parameter and I wanted to set up
a parameter list that I could just put the whole thing in one command where
we define only what we need in the definition of the array:

I tried:

Dim parameters As SqlParameter () = { _
New SqlParameter("@ClientID",SqldbType.VarChar,20,session("ClientID")),
_
New SqlParameter("@username",SqlDbType.VarChar,20,UserName.text), _
New SqlParameter("@Password",SqlDbType.VarChar,20,Password.Text) }

But I got an error:

Procedure 'GetUserInfo' expects parameter '@ClientID', which was not
supplied

But if I take out the last argument of each "New SqlParameter' statement and
add the data later it works fine.

****************************************
Dim parameters As SqlParameter () = { _
New SqlParameter("@ClientID",SqldbType.VarChar,20), _
New SqlParameter("@username",SqlDbType.VarChar,20), _
New SqlParameter("@Password",SqlDbType.VarChar,20) }

parameters(0).value = session("ClientID")
parameters(1).value = UserName.text
parameters(2).value = Password.Text
*********************************************

I was hoping to be able to add values in during the "New" statement.

Thanks,

Tom
 
Back
Top