We have emailed a link with querystring to people. When they click and open the page for this link, their name and account id are auto populated with the querystring. They click to submit the form and the data gets saved to our sql server database in a table.
My issue is that at random a row will be saved with a previous personas name and account, even if it was not them that submitted it. The a few more get posted properly and then another with that same name will get inserted. Then it might not happen for 20
or more rows.
I have checked the code and it looks fine. The connection is closed the command and transaction objects are disposed of. The querystring data for the people looks to be correct.
There must be something that I'm missing in the process, but I'm unsure of where to look further.
The site and form being submitted are on a shared hosted site. The site has good bandwidth and plenty of apppool memory (500MB).
Can anyone of ...
Go to the complete details ...