HackedCity
New Member
I have a table generated by Access database using loop. How can I make it possible to update those records all at once by clicking an Update button.I guess my question was not detailed enough. So I am explaining my question here. What I want to do is this. I have an Access database for game scores. I generate a form for a certain group of users and their scores in a table. I want to update the scores for those users all at once. I do not want to shw each user in a input box and send it along with his new scores because the person who is update the scores may change the username by mistake. Only the scores need to be updated. Please help me. Thank you.This appears to be more of a conceptual question, rather than an ASP.NET question. As such, I don't have any ASP.NET-specific code to offer you, however I have run into this problem before.<BR><BR>In the past, in Classic ASP, I've been forced to loop through the form collection on the "action" page and analyze each formElement and value, and perform a SQL update within the loop if applicable. It's worked for me in the past but I'm unsure if this is the best way. Perhaps passing the form collection values to a stored procedure would be more efficient. If anyone has any brilliant ideas, I'd be interested in hearing them.