update query in ms-access doesn't working

[abhilashcashok]

hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.

I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.

But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.

I'm using VS.NET 2005 & MS ACCESS 2003.

please help me...its urgent.

i'm including the code below :

*****************************************************************

string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";

try
{
OleDbConnection oc = new OleDbConnection(provider);
OleDbCommand od = new OleDbCommand(sql, oc);
oc.Open();

od.ExecuteNonQuery();

oc.Close();
}
catch (Exception exp)
{
return exp.Message;
}

*****************************************************************

My table contains two field : "ID" & "Password", both are of String
type.

*****************************************************************

thanks in advance

 

[Nicholas Paldino [.NET/C# MVP]]

I'm not sure, but perhaps it is the quotes in the string (mabye it is
looking for a double-quote)?

I doubt that your string is a constant like that, but rather, a string
that you concatenate together. In this case, you should use a parameterized
query, and let the provider handle the parameter formatting issues for you.

 

[Arne Vajhøj]

hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.

I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.

But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.

string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";

Maybe password is a reserved word.

Try:

string sql = "update Table1 set [Password] = 'modify' where ID = 'abhi'";

Arne

 

[christery]

hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.

I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.

But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.
string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";

Maybe password is a reserved word.

Try:

string sql = "update Table1 set [Password] = 'modify' where ID = 'abhi'";

Arne

check if an @ might help... donno why but test string sql = @"update
Table1 set Password = 'modify' where ID = 'abhi'";
dont think password is reserved, but new to c#

//CY

 

[Arne Vajhøj]

hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.
I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.
But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.
string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";

Maybe password is a reserved word.

Try:

string sql = "update Table1 set [Password] = 'modify' where ID = 'abhi'";

check if an @ might help... donno why but test string sql = @"update
Table1 set Password = 'modify' where ID = 'abhi'";

The @ should not have any impact here - no \ characters.

dont think password is reserved

http://support.microsoft.com/kb/248738 claims it is.

Arne

 

[christery]

http://support.microsoft.com/kb/248738claims it is.

Arne- Dölj citerad text -

- Visa citerad text -

I stand corrected, was thinking just C#, not access

//CY