asifeqbal

 Profile Answers by asifeqbal 

• Mar 19th, 2015

 

Code
EXEC [dbo].[<Stored_Procedure Name>] [Parameters1, Parameters2 ....etc. ]

asifeqbal

 Profile Answers by asifeqbal 

• Mar 19th, 2015

 

Code
 SqlCommand command = new SqlCommand("dbo.sp_name", (SqlConnection)session.Connection);


 command.CommandType = CommandType.StoredProcedure;


 command.Parameters.Add(new SqlParameter("@param_name1", "Param Value 1"));


 command.Parameters.Add(new SqlParameter("@param_name2", "Param Value 1"));


 command.ExecuteNonQuery();