srivatchu says:
SqlCommand cmd =
new
SqlCommand(
"update Incident_Details set breach_reason = @breach_reason , Resolution_Cateogarization = @Resolution_Cateogarization where Incident_Number = @Incident_Number"
);
cmd.Parameters.AddWithValue(
"@Resolution_Cateogarization"
, row.Cells[3].Controls.OfType<TextBox>().FirstOrDefault().Text);
cmd.Parameters.AddWithValue(
"@breach_reason"
, row.Cells[4].Controls.OfType<DropDownList>().FirstOrDefault().SelectedItem.Value);
cmd.Parameters.Add(
"@Incident_Number"
, SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
this
.ExecuteQuery(cmd,
"SELECT"
);
Replace above code with below.
SqlCommand cmd = new SqlCommand("update Incident_Details set breach_reason = @breach_reason , Resolution_Cateogarization = @Resolution_Cateogarization where Incident_Number = @Incident_Number");
cmd.Parameters.AddWithValue("@Resolution_Cateogarization", row.Cells[3].Controls.OfType<TextBox>().FirstOrDefault().Text);
cmd.Parameters.AddWithValue("@breach_reason", row.Cells[4].Controls.OfType<DropDownList>().FirstOrDefault().SelectedItem.Value);
cmd.Parameters.Add("@Incident_Number", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Incident_Number", row.Cells[1].Controls.OfType<TextBox>().FirstOrDefault().Text);
this.ExecuteQuery(cmd, "UPDATE");