Hey,
I've run into a problem with a webpage I'm building. I have a WebDataGrid that has an oracle table as a datasource, and I've enabled the editing core behaviors to support editing individual cells in the rows. Whenever I edit a cell and refresh the page, it throws an error
"Sys.WebForms.PageRequestManagerServerErrorException: Original data source does not support updates."
google has been unhelpful, and I'm not sure which direction to head. I had a problem with an invalid DataKeyField earlier, but as soon as I resolved that, this appeared.
Hi testhandle,
You are probably using AutoCrud to do updating. You are correct that you need the data key fields set. But when you set up the DataSource object on the page, you need to be sure that it allows updates, adds, or deletes. Otherwise, our code cannot modify it.
regards,David Young
Hi Dave,
I am using AUTOCRUD to update, and I have the DataKeyField set to the primary key on the table. I'm using a SQLDataSource in VB2008 configured for an Oracle table to fill my Grid. I'm not sure how to allow updates, adds, or deletes on my table.
Is it something I need to change in the html for the table? Or is it a property in the editing core?
You most likely need to modify the definiton of you SqlDataSource object on the aspx to have update parameters. You should be able to find out about them online. Or Visual Studio can try to autogenerate them if you use the designer.
-Dave
Okay. Back with a slightly more intelligent take on the situation. I've added an update parameter to the aspx and update command, with just test values to see if it could read/process those, and I'm being thrown this
sys.webforms.pagerequestmanagerservererrorexception ORA-01036: illegal variable name/number
This is my aspx markup...the query works just fine when run from a table editor. UpdateCommand ="UPDATE SOME_TABLE SET SOME_COLUMN = 'Test'">
UpdateCommand
<UpdateParameters>
<asp:Parameter Name="SOME_COLUMN" Type="String" DefaultValue="TestValue"> </asp:Parameter>
</UpdateParameters>