Syntax error in UPDATE statement

Question

1.00/5 (3 votes)

See more:

hi i have "(Syntax error in UPDATE statement.)" when I updating the record in access database by c# source code:

C#

OleDbConnection connect = new OleDbConnection(@"path.mdb");
           OleDbCommand cmd = new OleDbCommand();

               cmd.CommandType = CommandType.Text;
               cmd.CommandText = "UPDATE Table2 set check=2 whene key=asd ";
               cmd.Connection = connect;
               connect.Open();
               cmd.ExecuteNonQuery();
               connect.Close();

thank you for solution my problems

Posted 13-Aug-12 22:59pm

jihad anwar

Updated 13-Aug-12 23:00pm

Mehdi Gholam

v2

Add a Solution

5 solutions

Solution 4

I had the same problem long back, i added textbaox1.text.tostring(); it works fine.

in your code also use richTextBox2.Text.tostring();

Posted 13-Aug-12 23:41pm

D-Kishore

Comments

jihad anwar 14-Aug-12 5:53am

thanks
but not solved please help me.

Solution 5

why are you giving check value in quotes.Try giving lik this in your code.

SQL

cmd.CommandText = "UPDATE Table2 set check=2 where  key='"+richTextBox2.Text+"' ";

Posted 14-Aug-12 0:20am

ajithk444

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)

Santhosh Kumar Jayaraman · Accepted Answer · 2012-08-13T23:07:00

Solution 3

Your keyword is incorrect .

It should be where instead of whene.
Also When you are using string in where clause, it should be written in single quotes.
like 'asd' instead of asd

C#

cmd.CommandText = "UPDATE Table2 set check='2' where key='asd'";

Posted 13-Aug-12 23:07pm

Santhosh Kumar Jayaraman

Updated 14-Aug-12 0:11am

v4

Comments

AshishChaudha 14-Aug-12 5:09am

my 5!

jihad anwar 14-Aug-12 5:17am

thanks

i checked it but i did not get correct answer.
please help me again

Santhosh Kumar Jayaraman 14-Aug-12 5:22am

post ur code again

Rahul Rajat Singh 14-Aug-12 5:19am

+5.

jihad anwar 14-Aug-12 5:28am

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace qamus
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
OleDbConnection connect = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=E:\qamus.mdb");

private void button1_Click(object sender, EventArgs e)
{

OleDbCommand cmd = new OleDbCommand();

cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE Table2 set check='2' where key='"+richTextBox2.Text+"' ";
cmd.Connection = connect;
connect.Open();
cmd.ExecuteNonQuery();
connect.Close();

}

private void richTextBox2_TextChanged(object sender, EventArgs e)
{

}
}
}

Santhosh Kumar Jayaraman 14-Aug-12 5:30am

And wat was the error now? Are there errors? or record is not updated? If there are no errors and record is not updated, then is the connection is valid?

jihad anwar 14-Aug-12 5:39am

thanks a lot for help me.
but i have same error in my code till now
and this code bellow to for "select" option is true
but for "update" has same problems

cod to select option :

OleDbCommand command = new OleDbCommand();
command.Connection = connect;
connect.Open();
string cmdstr = "select Count(key) from Table2 where key='" + richTextBox2.Text + "'";
OleDbCommand che1 = new OleDbCommand(cmdstr, connect);
int ku1 = Convert.ToInt32(che1.ExecuteScalar().ToString());
connect.Close();

Santhosh Kumar Jayaraman 14-Aug-12 5:45am

So if its working for select , then it should work for update, because the syntax for update is correct. Can you clean the solution and try again

jihad anwar 14-Aug-12 5:50am

thanks for every think
at last please the correct code for update option send to me again for here .
((* regards *))

Santhosh Kumar Jayaraman 14-Aug-12 5:59am

Btw what is the check column datatype?

this code is correct.

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace qamus { public partial class Form3 : Form { public Form3() { InitializeComponent(); } OleDbConnection connect = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=E:\qamus.mdb"); private void button1_Click(object sender, EventArgs e) { OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE Table2 set check='2' where key='"+richTextBox2.Text+"' "; cmd.Connection = connect; connect.Open(); cmd.ExecuteNonQuery(); connect.Close(); } private void richTextBox2_TextChanged(object sender, EventArgs e) { } } }

jihad anwar 14-Aug-12 6:07am

ID AutoNumber
key Text
check Text

until now i have an error

Santhosh Kumar Jayaraman 14-Aug-12 6:10am

its strange. Still you are getting Syntax error in UPDATE statement? or any other error?

kmoorevs 11-Mar-24 17:08pm

As others have said, given the field names you have provided, (check and key) it's highly likely that as others have said, you need to bracket the field names as these are pretty good candidates for reserved words. Different providers may have their own rules, but the safest bet is to not name your database fields with words that are likely to be sql/access reserved words.

AshishChaudha · Accepted Answer · 2012-08-13T23:01:00

Solution 2

Please check following line and update it.

Please define the datatype of field check and key.

C#

cmd.CommandText = "UPDATE Table2 set check='2' where key='asd' ";

Thanks
Ashish

Posted 13-Aug-12 23:01pm

AshishChaudha

Updated 13-Aug-12 23:14pm

v3

Comments

jihad anwar 14-Aug-12 5:11am

thanks
but not solved
please help me as son as possible to answer me
because i need it so mach .

AshishChaudha 14-Aug-12 5:14am

please see my updated solution

Mehdi Gholam · Accepted Answer · 2012-08-13T23:01:00

Solution 1

Edit to :

C#

cmd.CommandText = "UPDATE Table2 set check=2 where key='asd' ";

EDIT :
If you are using an Access database your connection string must be : http://www.connectionstrings.com/access/[^]

Posted 13-Aug-12 23:01pm

Mehdi Gholam

Updated 13-Aug-12 23:21pm

v2

Comments

jihad anwar 14-Aug-12 5:07am

thanks
but not solved

jihad anwar 14-Aug-12 5:07am

please help me

Mehdi Gholam 14-Aug-12 5:21am

Check the update.