Passing SqlParameter not accepting value

[tshad]

I am trying to build my own DB Class and am trying to set up my parameter
list in an array of SqlParameter objects.

In my regular code I would do something like:
*************** *************** *************** ************
Dim dbCmd As SqlCommand = New SqlCommand("Get Users", dbConn)
dbCmd.CommandTy pe = CommandType.Sto redProcedure

dbCmd.Parameter s.Add("@UserID" ,SqlDBType.Int) .value = 1
*************** *************** *************** ***************

In this I add the the value dircectly into the .Add SqlParameter statement.

In my class, I get an error if I do the same thing and have to do the
assignment afterwords:
*************** *************** ********
Sub LoadGrid()
Dim parameters as SqlParameter() = { _
New SqlParameter("@ UserID",SqlDBTy pe.Int) }

parameters(0).v alue = 1
*************** *************** ***********

Is there a way to do the above line in one statement, such as:

New SqlParameter("@ UserID",SqlDBTy pe.Int).value = 1

Thanks,

Tom

[tshad]

What I get as an error message is:

Specified cast is not valid.

Thanks,

Tom

"tshad" <tf*@dslextreme .comwrote in message
news:ee******** ******@TK2MSFTN GP03.phx.gbl...

>I am trying to build my own DB Class and am trying to set up my parameter
list in an array of SqlParameter objects.

In my regular code I would do something like:
*************** *************** *************** ************
Dim dbCmd As SqlCommand = New SqlCommand("Get Users", dbConn)
dbCmd.CommandTy pe = CommandType.Sto redProcedure

dbCmd.Parameter s.Add("@UserID" ,SqlDBType.Int) .value = 1
*************** *************** *************** ***************

In this I add the the value dircectly into the .Add SqlParameter
statement.

In my class, I get an error if I do the same thing and have to do the
assignment afterwords:
*************** *************** ********
Sub LoadGrid()
Dim parameters as SqlParameter() = { _
New SqlParameter("@ UserID",SqlDBTy pe.Int) }

parameters(0).v alue = 1
*************** *************** ***********

Is there a way to do the above line in one statement, such as:

New SqlParameter("@ UserID",SqlDBTy pe.Int).value = 1

Thanks,

Tom

[Scott Roberts]

How about this:

dbCmd.Parameter s.AddWithValue( "@UserID",1 )

"tshad" <tf*@dslextreme .comwrote in message
news:ee******** ******@TK2MSFTN GP03.phx.gbl...

>I am trying to build my own DB Class and am trying to set up my parameter
list in an array of SqlParameter objects.

In my regular code I would do something like:
*************** *************** *************** ************
Dim dbCmd As SqlCommand = New SqlCommand("Get Users", dbConn)
dbCmd.CommandTy pe = CommandType.Sto redProcedure

dbCmd.Parameter s.Add("@UserID" ,SqlDBType.Int) .value = 1
*************** *************** *************** ***************

In this I add the the value dircectly into the .Add SqlParameter
statement.

In my class, I get an error if I do the same thing and have to do the
assignment afterwords:
*************** *************** ********
Sub LoadGrid()
Dim parameters as SqlParameter() = { _
New SqlParameter("@ UserID",SqlDBTy pe.Int) }

parameters(0).v alue = 1
*************** *************** ***********

Is there a way to do the above line in one statement, such as:

New SqlParameter("@ UserID",SqlDBTy pe.Int).value = 1

Thanks,

Tom