I am trying to implement the scenario mentioned in 'http://aspalliance.com/539'
. They say that you can't addrows using the gridview on an access database, and so you have to use the detailsview in association with the gridview as they mention in their article.
I can get everything to work, except for the update query. Forgetting about the detailsview, I still can't get the update query on the gridview to work. I can get for instance, the first query below to work, but the second query which uses a ? symbol in both cases doesn't update anything. Just doesn't work. However, the strange thing is that I downloaded and implemented the project defined in 'http://aspalliance.com/539'
and it works perfectly. The query is exactly the same format and works fine. So, I can't for the life of me figure out what is wrong?
In fact, I basically used their objects and transferred the data from my table into theirs, deleting all their data of course and changing the queries to suit me... and it worked perfectly, the second query below worked fine! But, then I added the details view to it and it randomly stopped working again? Looks like this website won't allow me to attach the aspx page to show the problem. How to solve?
Any help would be greatly appreciated.
UPDATE [User Information] SET [User Name] = ? WHERE (ID ='1234')
This does not work:
UPDATE [User Information] SET [User Name] = ? WHERE (ID = ?)