neesha herath

neesha herath

  • NA
  • 16
  • 3.1k

Update code message box

Sep 10 2013 12:48 AM

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");

                   cs.Close();

               }

 

        }


Answers (6)