[RESOLVED] Need help with cycle issue

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 offer any suggestions on what to look for?

Hi,

Jackxxx

My issue is that at random a row will be saved with a previous personas name and account

I am not quite sure why this issue would happen. Based on the user name and account, it's able to update the corresponding row, so you should check the corresponding codes.

Check whether you are using any Session variables and that causes the problem. Also ensure that you do not have any Static Class or
Static Members which involves in this operation. 

We had encountered a similar problem where in we were having a Static instance for our User details. When the 1st user logs in and performs soem operation everything was working well. We were seeing the 1st users credentials getting inserted into the database.
The moment one more users logs into the website (from some other machine) all the operations doen by user 1 were recorded in the database in the name of User 2.

Hope this helps.