Retrieve stored procedure parameters before execute

  • Thread starter Thread starter Laurent
  • Start date Start date
L

Laurent

Hi,

I would like to retrieve the names of the parameters of a strored procedure
without execute it...

Any idea ?
 
Not sure what you are trying to accomplish, but if you mean client side,
then you can just iterate the command.Parameters Collection. Don't think
you can do it otherwise (namely finding out from the Stored Proc) without a
trip to the Database.

HTH,

Bill
 
Huh?
Like ADO classic, you can get ADO.NET to construct a rudimentary (not always
correct) set of Parameter objects for you and populate the Parameters
collection by using the CommandBuilder.DeriveParameters method. Yes, this
takes a round trip to the server unless you set the RPM (Read Programmer's
Mind) property. It does not, however execute the SP.

hth
--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top