Hi
below code is an update code. In this message boxes are not working properly. When I click the update button it always display the "record has been updated" message box.
Please help me..
private void ButtUpdate_Click(object sender, EventArgs e)
{
int x;
da.UpdateCommand = new SqlCommand("UPDATE EWO_DETAILS SET CONTRACTOR_CODE = @ CONTRACTOR_CODE, START_DATE = @START_DATE, END_DATE = @END_DATE, CREATED_BY = @CREATED_BY , CREATED_DATE = @CREATED_DATE WHERE EWO_NO = @EWO_NO", cs);
da.UpdateCommand.Parameters.Add("@CONTRACTOR_CODE", SqlDbType.VarChar).Value = TxtContractorCode.Text;
da.UpdateCommand.Parameters.Add("@EWO_SPEC", SqlDbType.VarChar).Value = TxtEwoSpec.Text;
da.UpdateCommand.Parameters.Add("@CAT", SqlDbType.VarChar).Value = TxtJcat.Text;
da.UpdateCommand.Parameters.Add("@MAIN", SqlDbType.VarChar).Value = TxtJmain.Text;
da.UpdateCommand.Parameters.Add("@SPEC", SqlDbType.VarChar).Value = RTBSpec.Text;
da.UpdateCommand.Parameters.Add("@SUB", SqlDbType.VarChar).Value = TxtSub.Text;
da.UpdateCommand.Parameters.Add("@XTC", SqlDbType.VarChar).Value = TxtExtc.Text;
da.UpdateCommand.Parameters.Add("@START_DATE", SqlDbType.VarChar).Value = StartDatePicker.Value.Date;
da.UpdateCommand.Parameters.Add("@END_DATE", SqlDbType.VarChar).Value = EndDatePicker.Value.Date;
da.UpdateCommand.Parameters.Add("@CREATED_BY", SqlDbType.VarChar).Value = TxtCreatedBy.Text;
da.UpdateCommand.Parameters.Add("@CREATED_DATE", SqlDbType.VarChar).Value = CreatedDatePicker.Value.Date;
da.UpdateCommand.Parameters.Add("@EWO_NO", SqlDbType.Int).Value = ds.Tables[0].Rows[bs.Position][0];
cs.Open();
try
x = da.UpdateCommand.ExecuteNonQuery();
cs.Close();
if (x >= 1)
MessageBox.Show("Record has been Updated ");
}
else
MessageBox.Show("Record Already Updated ", "Error");
catch
MessageBox.Show("Error on update please reloggin", "Information");