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("You r sp name", connection)
command.Command Type = CommandType.Sto redProcedure
command.Paramet ers.Add("@a", SqlDbType.NVarC har, 50).Value = "some
value"
command.Paramet ers.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.Disp ose()
command.Dispose ()
da.Dispose()
End Try

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Lacka" <la***@chello.h u> wrote in message
news:en******** ********@TK2MSF TNGP14.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!