I have some code which calls a stored procedure
Dim cn As New SqlConnection("Data Source=localhost; Initial Catalog=lergdb; User ID=sa; Password=")
Dim Sql As String
Sql = "sp_getNpaInfo"
Dim cmd As New SqlCommand(Sql, cn)
cmd.CommandType = CommandType.StoredProcedure
Dim dr As SqlDataReader = cmd.ExecuteReader()
i would to like to be able to do the folowing...
a) bind the resault to a controle like a grid or so...
b) read dat data into a table of a dataset
c) able to tell how many rows are in the resault..