Listing Database Store Procedurs using C# ADO.Net


Listing all the available store procedures of database using i very easy, see the bellow code for more clerification.

SqlConnection connection = new SqlConnection("ConnectionString");

SqlCommand command = new SqlCommand("select name as TableName,create_date from sys.procedures", connection);

SqlDataAdapter adapter = new SqlDataAdapter(command);

DataTable dataTable = new DataTable();


Above code lists store procedure name and created date