Stored Procedure

[Anavim]

Hi !

I need an example of how to run through VB a stored procedure that place in my DB whuch return a record set.

This stored procesdure get few (3) input values in order to run it.

Thanks.

I need the example which contain all.

[Nigh™a®e]

Hi,

This is easy,
Use the SQLCommand and SQLConnection from the System.Data

For the SQLCommand you can set the name of the Stored Proc, and add some input parameters

Dont have the right code here, but tested with it.
I created 1 function that has an SQLParameter() input,

then you only have to set the parameters (input / output) and set the name of the procedure.

I will provide the code of the function here tomorow.