Use right syntax error in Mysql

Question

Am not able to fix the error below:

`"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'When,Then) values( '79','WBT-CoE','gyj','yi','yi')' at line 1"` error.

Here's the code:

 protected void Button3_Click(object sender, EventArgs e){

        string MyconnectionString = "server=localhost;database=requirement_doc;Uid=t;Pwd=123;";
        MySqlConnection conn = new MySqlConnection(MyconnectionString);
        MySqlCommand cmd;

        DataTable dt1 = new DataTable();
        cmd = conn.CreateCommand();

        cmd.CommandText = "SELECT  Req_ID, Actor FROM UseCase where Req_ID='" + txtReqID.Text + "' AND Actor='" + DropDownList1.Text + "'";
                    MySqlDataAdapter da1 = new MySqlDataAdapter();
        da1.SelectCommand = cmd;
        da1.Fill(dt1);

        if (dt1.Rows.Count > 0)
        {

            Label1.Text = "Data already exist";

        }


        else
        {


            string sql = "INSERT INTO UseCase (Req_ID,Actor,Given,When,Then) values(  '" + txtReqID.Text + "','" + DropDownList1.Text + "','" + giventxt.Text + "','" + whentbl.Text + "','" + thentbl.Text + "')"; 

                          cmd.Connection = conn;
            cmd.CommandText = sql;
            conn.Open();



        }
        try
        {

            cmd.ExecuteNonQuery();
            Label1.Text = " Successfully saved";
        }

        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }
    }

dev.mysql.com/doc/refman/5.5/en/reserved-words.html

juergen d
– juergen d

2013-06-28 11:34:55 +00:00
Commented Jun 28, 2013 at 11:34 — juergen d
– juergen d, Commented Jun 28, 2013 at 11:34

Lohit · Accepted Answer · 2013-06-28 11:34:10Z

2

Surround When and then with `` because they are reserved names.

string sql = "INSERT INTO UseCase (Req_ID,Actor,Given,`When`,`Then`) values(  '" + txtReqID.Text + "','" + DropDownList1.Text + "','" + giventxt.Text + "','" + whentbl.Text + "','" + thentbl.Text + "')";

answered Jun 28, 2013 at 11:34

Lohit

1268 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jan Dörrenhaus · Accepted Answer · 2013-06-28 11:33:05Z

1

When and Then are reserved names in MySQL. So if you use those as column names, you get that error.

answered Jun 28, 2013 at 11:33

Jan Dörrenhaus

6,7172 gold badges36 silver badges45 bronze badges

Collectives™ on Stack Overflow

Use right syntax error in Mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related