UPDATE Command in SqlDataSource Control Works Only Once
Posted on 2008-10-17
I have a simple ASP.NET page where I am updating a user's selection via a dropdown list. i.e., They make a choice; they have a value stored in the backend database table representing that value (choice). The Choice table holds both the user's ID and the choice ID. When I first initiate the table (more on what that means in a second), I can use an EditItemTemplate to change any of the choice values for any of the players only ONCE EACH. i.e., If I go back to change a field value that I have already changed once, it will not accept the change a subsequent time. However, and this is what I mean by initiate the table, when I make changes in values directly in the database tables, it sort of resets the table and/or values and "starts it over" so I can make changes again when I launch the page. Then I can do this all over again, once for each user. I have gone over and over my SQL and I am sure it is correct. I have looked at the table properties and am not finding anything that would be a permission or table/field property issue. I hope this is enough infirmation for someone to offer assistance and/or suggestions. Thanks in advance. Also, this is someone else's project. He came to me for help and I'm stuck. I'll check with him and if OK, I'll attach a code snippet to help this along. Thanks again!