How to call parameterized stored procedure to return result set?

[Lacka]

Hi,

If I have a stored procedure in my database, that has two parameters (say @a
nvarchar(50) and @b int), and returns the result of a SELECT statement
(returns a result set), how can I set up the parameters, how can I call it,
and how can I iterate through the rows of the returned resultset?

thanks,
Lacka

[Karl Seguin]

Lacka, I answered how to return iterate through it in your other post, as
for your two other questions:

Dim connection As New SqlConnection("...")
Dim command As New SqlCommand("Your sp name", connection)
command.CommandType = CommandType.StoredProcedure
command.Parameters.Add("@a", SqlDbType.NVarChar, 50).Value = "some
value"
command.Parameters.Add("@b", SqlDbType.Int).Value = 1
Dim da As New SqlDataAdapter(command)
Try
Dim ds As New DataSet
connection.Open()
da.Fill(ds)
Finally
connection.Dispose()
command.Dispose()
da.Dispose()
End Try

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Lacka" <la***@chello.hu> wrote in message
news:en****************@TK2MSFTNGP14.phx.gbl...

Hi,

If I have a stored procedure in my database, that has two parameters (say @a nvarchar(50) and @b int), and returns the result of a SELECT statement
(returns a result set), how can I set up the parameters, how can I call it, and how can I iterate through the rows of the returned resultset?

thanks,
Lacka

[Lacka]

Thanks!