Introduction
Listing all the available store procedures of database using ado.net i very
easy, see the bellow code for more clerification.
SqlConnection connection
= new SqlConnection("ConnectionString");
connection.Open();
SqlCommand command =
new SqlCommand("select
name as TableName,create_date from sys.procedures", connection);
SqlDataAdapter adapter =
new SqlDataAdapter(command);
DataTable dataTable =
new DataTable();
adapter.Fill(dataTable);
Above code lists store procedure name and
created date