Get a list of SQL Stored procedure parameters from database

[Gurnandan]

Hi,

I am trying to modify a common function in SQLHelper class
of the DAAB, which will return the SQL parameters for a
stored proc. I am passing the connection string and the
stored procedure name to it. How do I get the parameters
from the database. The reason, I need to do this, because
I am using Beta2 version and Deriveparameters function
doesnot work in beta 2. How can I achieve the same
functionality?


Please Help!!!!


Thanks in advance.

 

[anouk]

You could use the following command in sql server:

exec sp_help 'mystoredprocedure'

this will give you detailed info on the stored procedure, including the
parameters.

Hope this helps...