How do we call and execute a Stored Procedure in Dot Net?

Answer:

By Using SqlCommand object of System.Data.SqlClient namespace,we can execute our Stored Procedure from Code-Behind

We have to pass Stored Procedure Name in CommandText property of SqlCommand object as:-

cmd.CommandType = CommandType.StoredProcedure;

cmd.Commandtext = "our stored procedure name";

cmd.ExecuteNonQuery();

Here,cmd is or SqlCommand object.