Last post Oct 14, 2008 04:47 PM by Mikesdotnetting
Oct 13, 2008 11:44 PM|rj2585|LINK
I'm developing a ASP. net web site. I'm using the control form view to display the data of a MS Access 2000 Database. If I tried to use the command new, it works as expected, but if I try to use the command update or delete the application shows the following
In another post someone suggested that the cause was a problem in the access source but I don't see any errors in the code.
Here is the code:
Oct 14, 2008 08:50 AM|Mikesdotnetting|LINK
Your parameter markers don't match the Parameter declarations. Do you really mean to use CompareAllValues as your ConflictDetection property? I suspect not - given th SQL you are trying to execute. I would try using the DataSource control's configuration
wizard to reset the commands.
Oct 14, 2008 04:36 PM|rj2585|LINK
That code was generated by the DataSource control's configuration wizard
Oct 14, 2008 04:47 PM|Mikesdotnetting|LINK
Do not check the option to "Use Optimistic Concurrency" when configuring the datasource.