How to retrieve stored proc parameter info?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In ADODB, the Command.Parameters.Refresh method brings back parameter information for an SQL stored procedure from the database - the Parameters collection is populated with the expected names and types etc.

Is there a way to do this in ADO.NET - I haven't found it yet ?
 
DeriveParameters method

Howard Green said:
In ADODB, the Command.Parameters.Refresh method brings back parameter
Click to expand...
information for an SQL stored procedure from the database - the Parameters
collection is populated with the expected names and types etc.
 
See my article on the Command Builder to see why it's not a good idea to use
this approach.
www.betav.com/articles

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

Howard Green said:
In ADODB, the Command.Parameters.Refresh method brings back parameter
Click to expand...
information for an SQL stored procedure from the database - the Parameters
collection is populated with the expected names and types etc.
 
I agree, 100%, one should use DeriveParameters with caution. However,
its the only way 'out of the box' I know to do what the poster asked.
 
Back
Top