syntax of update query for multiple column update

Question

0.00/5 (No votes)

See more:

I had to update a table i tried two queries but it shows syntax error can anyone help me pls I know this is basic but i am a begginer

C#

String query = "Update masterusertable set username='" + txtName.Text + "',and set password='" + txtpassword.Text + "',and set phoneno='" + txtphoneno.Text + "',and set adress='" + rtxtAdress.Text + "' where userid ='" + txtuserid.Text + "'";




String query = "Update masterusertable set username='" + txtName.Text + "', password='" + txtpassword.Text + "', phoneno='" + txtphoneno.Text + "', adress='" + rtxtAdress.Text + "' where userid ='" + txtuserid.Text + "'";

its shows oledbexception due to syntax error in update statement ,no the userid is text but unique NON DUPLICABLE
anyother idea i had many big tables to be updated is it good to update using anyother ideas

Posted 3-Feb-11 1:39am

SREENATH GANGA

Updated 3-Feb-11 1:52am

v3

Add a Solution

Comments

Prerak Patel 3-Feb-11 7:44am

Don't forget to share the exact error. It would be much easier for us to help you in that way.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Accepted Answer · 2011-02-03T01:42:00

Solution 1

Your second query looks good, but if userid is a numeric field, use following

C#

String query = "Update masterusertable set username='" + txtName.Text + "', password='" + txtpassword.Text + "', phoneno='" + txtphoneno.Text + "', adress='" + rtxtAdress.Text + "' where userid =" + txtuserid.Text;

Posted 3-Feb-11 1:42am

Prerak Patel

Comments

SREENATH GANGA 3-Feb-11 7:51am

its shows oledbexception due to syntax error in update statement ,no the userid is text but unique NON DUPLICABLE

Prerak Patel 3-Feb-11 7:56am

Then your 2nd query is perfect by syntax. Check the field names, do they match perfectly. I can see "address" spelled wrong as "adress". Is it same in database? What is the exact error message? Any pointer to the error?

SREENATH GANGA 5-Feb-11 2:47am

OleDbConnection oleDbConnection1 = new System.Data.OleDb.OleDbConnection(connString);
oleDbConnection1.Open();
String query = "Update masterusertable set username='" + userdata.Username + "',password='" + userdata.Passsword + "',phoneno=" + userdata.Phone + ", adress='" + userdata.Adress1 + "' where userid ='" + userdata.Userid + "'";

OleDbCommand oleDbCommand1 = new System.Data.OleDb.OleDbCommand(query, oleDbConnection1);
oleDbCommand1.CommandType = CommandType.Text;

oleDbCommand1.ExecuteNonQuery();

oleDbConnection1.Close();
showdata12();
clearcontrol();

this was my code
error it points to
oleDbCommand1.ExecuteNonQuery();