Using multiple parameters for SqlConnection

[sck10]

Hello,

I have a stored procedure that requires 3 parameters. How do you add
multiple parameters for a SqlConnection?

Thanks, Steven
Public strConn = "Data Source=MyServer ;Initial Catalog=MyDatab ase;User
Id=MyUser;Passw ord=MyPwd;"
Dim cnnSearch As SqlConnection = New SqlConnection(s trConn)
Dim cmdRegion As SqlCommand = New SqlCommand("Sal esByCategory", cnnSearch)
cmdRegion.Comma ndType = CommandType.Sto redProcedure

Dim myParm As SqlParameter = cmdRegion.Param eters.Add("@Cat egoryName",
SqlDbType.VarCh ar, 15)
myParm.Value = "NorthAmeri ca"

cnnSearch.Open( )

Dim myReader As SqlDataReader = cmdRegion.Execu teReader()

[Marina]

It looks like you already know how to add parameters, so what's the problem?
Just do what you did to add 1 parameter, but do it 3 times.

"sck10" <sc***@online.n ospam> wrote in message
news:uo******** ******@TK2MSFTN GP15.phx.gbl...

Hello,

I have a stored procedure that requires 3 parameters. How do you add
multiple parameters for a SqlConnection?

Thanks, Steven
Public strConn = "Data Source=MyServer ;Initial Catalog=MyDatab ase;User
Id=MyUser;Passw ord=MyPwd;"
Dim cnnSearch As SqlConnection = New SqlConnection(s trConn)
Dim cmdRegion As SqlCommand = New SqlCommand("Sal esByCategory", cnnSearch)
cmdRegion.Comma ndType = CommandType.Sto redProcedure

Dim myParm As SqlParameter = cmdRegion.Param eters.Add("@Cat egoryName",
SqlDbType.VarCh ar, 15)
myParm.Value = "NorthAmeri ca"

cnnSearch.Open( )

Dim myReader As SqlDataReader = cmdRegion.Execu teReader()

[Kevin Yu [MSFT]]

Thanks for Marina's quick response!

Hi Steve,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to know how to add 3
parameters to a SqlCommand object. If there is any misunderstandin g, please
feel free to let me know.

Just like Marina mentioned, seems that you know how to add 1 parameter. You
can do it 3 times to add your 3 parameters, since SqlCommand.Para meters is
a collection, which can hold all the parameters required for the stored
procedure. The return value for the Add method is the reference to the
newly added parameter.

For more information, please check the following link:

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfSystemData SqlClientSqlCom mandClassParame tersTopic.asp

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Kevin Yu [MSFT]]

Hi Steve,

I'd like to know if this issue has been resolved yet. Is there anything
that I can help. I'm still monitoring on it. If you have any questions,
please feel free to post them in the community.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."