Get stored Procedure

1.using (SqlConnection conn = new SqlConnection (system.configuration.configurationmanager.connectionstrings[" LocalConnectionString "]. ConnectionString))
{
Conn. Open ();
SqlCommand com = new SqlCommand ();
Com. Connection = conn;
Com.commandtext = "Uppoint_all";//"Uppoint_all" Here is the name of the stored procedure.
Com.commandtype = CommandType.StoredProcedure;
Com. ExecuteNonQuery ();
Conn. Close ();
}

2.

SqlConnection conn = new SqlConnection (connectionstring);
SqlDataAdapter da = new SqlDataAdapter ();
Da. SelectCommand = new SqlCommand ();
Da. SelectCommand.Connection = conn;
Da.SelectCommand.CommandText = "nameofprocedure (' para1 ', ' para2 ', para3)";
Da.Selectcommand.CommandType = CommandType.StoredProcedure;

3.

SqlCommand cmd = new SqlCommand ("Proc_3", con);//Ibid.

Cmd.commandtype = commandtype.storedprocedure;//Ibid.

SqlDataAdapter da = new SqlDataAdapter (cmd);//Execute with SqlDataAdapter

DataTable table = new DataTable ();//Create a table

Da. Fill (table);//Populate table

return table;

Get stored Procedure