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=MyDatabase;User
Id=MyUser;Password=MyPwd;"
Dim cnnSearch As SqlConnection = New SqlConnection(strConn)
Dim cmdRegion As SqlCommand = New SqlCommand("SalesByCategory", cnnSearch)
cmdRegion.CommandType = CommandType.StoredProcedure

Dim myParm As SqlParameter = cmdRegion.Parameters.Add("@CategoryName",
SqlDbType.VarChar, 15)
myParm.Value = "NorthAmerica"

cnnSearch.Open()

Dim myReader As SqlDataReader = cmdRegion.ExecuteReader()

[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.nospam> wrote in message
news:uo**************@TK2MSFTNGP15.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=MyDatabase;User
Id=MyUser;Password=MyPwd;"
Dim cnnSearch As SqlConnection = New SqlConnection(strConn)
Dim cmdRegion As SqlCommand = New SqlCommand("SalesByCategory", cnnSearch)
cmdRegion.CommandType = CommandType.StoredProcedure

Dim myParm As SqlParameter = cmdRegion.Parameters.Add("@CategoryName",
SqlDbType.VarChar, 15)
myParm.Value = "NorthAmerica"

cnnSearch.Open()

Dim myReader As SqlDataReader = cmdRegion.ExecuteReader()

[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 misunderstanding, 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.Parameters 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/
frlrfSystemDataSqlClientSqlCommandClassParametersT opic.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."