Benefits of Stored Procedure: Steps to work with Parameters for Stored Procedure

so here we gave the information about Benefits of Stored Procedure:  Steps to work with Parameters for Stored Procedure . check below

Benefits of Stored Procedure:

 It reduce the burden on the database.

Improves the Application Performance.

User gets the Quick response.



Steps to work with Parameters for Stored Procedure

Declare Command Object.

SqlCommand cmd;

 Define Command Object.

Cmd=new SqlCommand(“[Procedure Name]”,con);

Declare Command Type as Stored Procedure.

cmd.CommandType=CommandType.StoredProcedure;

 Add the parameter list to the Command Object.

cmd.Parameters.AddWithValue(“[Parameter Name ]”,Value);

Execute the Command Object.

cmd.ExecuteNonQuery();

Latest Walkins 2013(updated every day )

Hyderabd Walkins 2013	walkins in chennai2013-14	walkins in Chandigarh2013
Walkins In Mumbai 2013	pune In Walkins 2013	Kolkata in walkins 2013
Ahmedabad JOBS 2013	Banglore walkins	Dotnet jobs