Depends on the platform. SQL server vs oracle vs whatever else.In oracle you can get a list off stored procs that you have access to via the ALL_OBJECTS view (with approriate where clause). then essentially you are gonna 'describe' each stored procedure to get the internal functions and parameters for each
cmd.CommandText = "TEST"; //Procedure-Name
cmd.CommandType = CommandType.StoredProcedure;
OracleCommandBuilder.DeriveParameters(cmd);foreach (OracleParameter par in cmd.Parameters)
{
MessageBox.Show(par.ParameterName + Environment.NewLine
+ par.Direction.ToString() + Environment.NewLine
+ par.OracleType.ToString() + Environment.NewLine
);
}
http://www.csdn.net/Develop/read_article.asp?id=21727