Hola, mira asi mando llamar yo mis ST's
Código:
Dim cmd As New SqlCommand("doppingsort", cnn) <--Stored Procedure
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection.Open()
cmd.Parameters.AddWithValue("@L", 1)
cmd.Parameters.AddWithValue("@U", 5)
Using sdr As SqlDataReader = cmd.ExecuteReader()
While sdr.Read()
table.AddCell(sdr(0).ToString())
table.AddCell(sdr(1).ToString())
table.AddCell(sdr(2).ToString())
table.AddCell(sdr(3).ToString())
table.AddCell(sdr(4).ToString())
Insertar()
End While
sdr.Close()
End Using
cmd.Connection.Close()