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