Updating multiple columns in Mysql using C# Textboxes

Question

I want to update 4 Columns in a particular row in MySQL using C#.I want to update the

value entered in text boxes into the database if a particular field already .I am using the

following query.

 string query = " update orderform set enrolmentexpected = " +
    textBox2.Text + " stockonhand=" + textBox3.Text + " numberrequired = "
    + textBox4.Text +  " where name = " + textBox1.Text + ";";

I am getting an exception that there is some error in mysql syntax but i am not able to

find such. Is my query right or there is some syntax mistake,and is there some way for

updating multiple columns

Steve · Accepted Answer · 2012-05-16 08:44:14Z

2

You have numerous problems in that line.

No comma between values
No parameters usage (with Sql Injection Problems)

Use something like this

using(MySqlConnection cn = GetConnection())
{
    cn.Open();
    string queryText = "update orderform set enrolmentexpected = ?en, stockonhand=?st, numberrequired=?num where name = ?name;";     
    MySqlCommand cmd = new MySqlCommand(queryText, cn);
    cmd.Parameters.AddWithValue("?en", textBox2.Text);
    cmd.Parameters.AddWithValue("?st", textBox3.Text);
    cmd.Parameters.AddWithValue("?num", textBox4.Text); // ?? require conversion to Int ???
    cmd.Parameters.AddWithValue("?name", textBox1.Text);
    cmd.ExecuteNonQuery();
}

answered May 16, 2012 at 8:44

Steve

217k22 gold badges242 silver badges296 bronze badges

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

Comments

Darshana · Accepted Answer · 2012-05-16 08:43:09Z

1

string query = " update orderform set enrolmentexpected = " +
textBox2.Text + ", stockonhand=" + textBox3.Text + ", numberrequired = "
+ textBox4.Text +  " where name = '" + textBox1.Text + "';"

guess that name is a string and other two int

answered May 16, 2012 at 8:43

Darshana

2,5486 gold badges30 silver badges58 bronze badges

Comments

dada686 · Accepted Answer · 2012-05-16 08:39:27Z

0

It seems you forgot the comma ',' after an expression :

string query = " update orderform set enrolmentexpected = " + textBox2.Text + ", stockonhand=" + textBox3.Text + ", numberrequired = " + textBox4.Text + " where name = " + textBox1.Text + ";";

and quotes too :

string query = " update orderform set enrolmentexpected = '" + textBox2.Text + "', stockonhand= '" + textBox3.Text + "' , numberrequired = '" + textBox4.Text + "' where name = " + textBox1.Text + ";";

answered May 16, 2012 at 8:39

dada686

4335 silver badges16 bronze badges

3 Comments

jaggi Over a year ago

@ dada686 When i am entering the previous name to update other columns in row it gives an exception that unknown column name, it takes the value entered into column name as name of the column

dada686 Over a year ago

@jaggi This error is because you forgot to put the comma and quotes, so the interpreter is confused as to who is what.

dada686 Over a year ago

@jaggi you should look at steve's answer, it is the best way to handle this situation.

Jainendra · Accepted Answer · 2012-05-16 08:41:55Z

0

It seems you are not using single quotes and commas.
Use this

string query = " update orderform set enrolmentexpected = '" +
textBox2.Text + "', stockonhand='" + textBox3.Text + "', numberrequired = '"
+ textBox4.Text +  "' where name = '" + textBox1.Text + "';";

This is valid in case all the datatypes are of type char or varchar.

answered May 16, 2012 at 8:41

Jainendra

25.2k30 gold badges132 silver badges172 bronze badges

Collectives™ on Stack Overflow

Updating multiple columns in Mysql using C# Textboxes

4 Answers 4

Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related