Updating Oracle table from a GridView

[bomayed]

Guys , I have connected to Oracle successfully using (Oracle.DataAccess)

I dropped SqlDataSource to my applicaiton , I choosed to datasource , selected the table and , and I finally draged and dropped a gridview, bind the gridview to the SqlDataSource.


I'm able to Insert , but when I try to update , I get nothing , I checked the update statement , and I modified the WHERE clause , and I got the following error message :


ORA-01036: illegal variable name/number

My update statement is :

UpdateCommand='UPDATE "DUTIE" SET "STATUS" =1' 

ConflictDetection="OverwriteChanges">

As you can see , I'm not even using parameters , I don't know why I am getting this error message!!


HELP

[mendhak]

I don't think you should need to use those quotes around the table name and column name. So your UpdateCommand should look like:

UpdateCommand="UPDATE Dutie SET Status = 1"...