Tuesday, September 6, 2011

Execute Stored Procedure with Parameters





protected void CallSPwithParams(string passedparameter)
{
using (SqlConnection sqlcon = new SqlConnection(dbconn))
 {
  string updatequerry = "StoredProcedureName";
  SqlCommand cmd = new SqlCommand(updatequerry, sqlcon);
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.Parameters.AddWithValue("@sqlparam", passedparameter );
  sqlcon.Open();
  cmd.ExecuteNonQuery();
  sqlcon.Close();
               
  }
}

No comments:

Post a Comment