"Ben" <ben@online.nospam> wrote in message
news:ad91d$429ca1a9$d8445835$11988@FUSE.NET...[color=blue]
> There are two sql parameter overloads that accept a value in the
> constructor.
>
>
http://msdn.microsoft.com/library/de...asp?frame=true
>
>
http://msdn.microsoft.com/library/de...asp?frame=true[/color]
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,sess ion("ClientID")),
_
New SqlParameter("@UserName",SqlDbType.VarChar,20,User Name.text), _
New SqlParameter("@Password",SqlDbType.VarChar,20,Pass word.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[color=blue]
>
> HTH,
> Ben
>
> "tshad" <tscheiderich@ftsolutions.com> wrote in message
> news:uHjDtMgZFHA.2900@TK2MSFTNGP15.phx.gbl...[color=green]
>> 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.VarCha r,20).value =
>> session("ClientID")
>> objCmd.parameters.add("@Email",SqlDbType.VarChar,4 5).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).valu e =
>> Session("ClientID"), _
>> New SqlParameter("@Email",SqlDbType.varChar,45).value =
>> Session("Email")}
>>
>> Thanks,
>>
>> Tom
>>[/color]
>
>[/color]
