C#.Net Message Box

hi,

in your code you written some extra braces that's why error showing.

i modified your code just copy paste below code and check:



private void ButtInsert_Click(object sender, EventArgs e)
        {
            try
            {
                if (TxtWorkOrderNo.Text == "")
                {
                    MessageBox.Show("Please enter a Work Order Number");
                }
                else if (Txtcat.Text == "")
                {
                    MessageBox.Show("Please enter CAT");
                }
                else if (Txtmain.Text == "")
                {
                    MessageBox.Show("Please enter MAIN");
                }
                else if (TxtSub.Text == "")
                {
                    MessageBox.Show("Please enter SUB");
                }
                else if (RTBSpec.Text == "")
                {
                    MessageBox.Show("Please enter SPEC");
                }
                else if (TxtEwoSpec.Text == "")
                {
                    MessageBox.Show("Please enter EWO_SPEC");
                }
                else if (TxtExtc.Text == "")
                {
                    MessageBox.Show("Please enter EXTC");
                }
                else if (TxtContractorCode.Text == "")
                {
                    MessageBox.Show("Please enter Contractor Code");
                }
                else if (TxtCreatedBy.Text == "")
                {
                    MessageBox.Show("Please enter Created By ?");
                }
                else
                {
                    SqlDataAdapter da = new SqlDataAdapter("Select SED_EWO_NO from where SED_EWO_NO='" + TxtWorkOrderNo.Text + "'", cs);
                    DataSet ds = new DataSet();
                    da.Fill(ds);
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        //stores the values entered as variables
                        string SED_EWO_NO = TxtWorkOrderNo.Text;
                        string SED_CAT = Txtcat.Text;
                        string SED_MAIN = Txtmain.Text;
                        string SED_SUB = TxtSub.Text;
                        string SED_SPEC = RTBSpec.Text;
                        string SED_EWO_SPEC = TxtEwoSpec.Text;
                        string SED_XTC = TxtExtc.Text;
                        string SED_CONTRACTOR_CODE = TxtContractorCode.Text;
                        string CREATED_BY = TxtCreatedBy.Text;
                        SqlCommand cmd = new SqlCommand();
                        string sql;
                        sql = "INSERT INTO EWO_DETAILS (SED_EWO_NO,SED_CONTRACTOR_CODE,SED_EWO_SPEC,SED_CAT,SED_MAIN,SED_SPEC,SED_SUB,SED_XTC,SED_START_DATE,SED_END_DATE,CREATED_BY,CREATED_DATE)";
                        sql += String.Format("VALUES ( @SED_EWO_NO, @SED_CONTRACTOR_CODE, @SED_EWO_SPEC, @SED_CAT, @SED_MAIN, @SED_SPEC, @SED_SUB, @SED_XTC, @SED_START_DATE, @SED_END_DATE, @CREATED_BY, @CREATED_DATE)");
                        cmd = new SqlCommand(sql, cs);
                        cmd.CommandText = sql;
                        cmd.CommandType = CommandType.Text;
                        cmd.Parameters.AddWithValue("@SED_EWO_NO", TxtWorkOrderNo.Text);
                        cmd.Parameters.AddWithValue("@SED_CONTRACTOR_CODE", TxtContractorCode.Text);
                        cmd.Parameters.AddWithValue("@SED_EWO_SPEC", TxtEwoSpec.Text);
                        cmd.Parameters.AddWithValue("@SED_CAT", TxtJcat.Text);
                        cmd.Parameters.AddWithValue("@SED_MAIN", TxtJmain.Text);
                        cmd.Parameters.AddWithValue("@SED_SPEC", RTBSpec.Text);
                        cmd.Parameters.AddWithValue("@SED_SUB", TxtSub.Text);
                        cmd.Parameters.AddWithValue("@SED_XTC", TxtExtc.Text);
                        cmd.Parameters.Add("SED_START_DATE", SqlDbType.VarChar).Value = StartDatePicker.Value.Date;
                        cmd.Parameters.Add("SED_END_DATE", SqlDbType.VarChar).Value = EndDatePicker.Value.Date;
                        cmd.Parameters.AddWithValue("@CREATED_BY", TxtCreatedBy.Text);
                        cmd.Parameters.Add("CREATED_DATE", SqlDbType.VarChar).Value = CreatedDatePicker.Value.Date;
                        cs.Open(); //opens connection
                        cmd.ExecuteNonQuery(); //writes to the database
                        MessageBox.Show("Details Added", "Successful");
                    }
                    else
                        MessageBox.Show("Already Present:" + TxtWorkOrderNo.Text);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show( ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                cs.Close(); // Close connection
            }
        }