Best method to prevent multiple entries

[KevinCB]

Hi,

I'm developing an asp.net site that will be used for online applications, basically data entry forms.

I have split the site into various steps, and to move between them there is a previous and next button on the page.

But one issue I discovered was that on the vey last step, which saves the details you entered into SQL Server, you could hit the backspace and apply again.

What would be the best method to stop people from entering multiple entries into the db server?

Is there any way I can detect if they have already entered into the db, or would disabling the backspace button be the easier option?

It's SQL Server 2000, possibly might move over to 2005.

 

[m0rte]

What sort of data is being submitted via the form?
Maybe you could ask for an email address or something and make that column of the database unique so if that email already exists you can make it update existing data instead or not insert anything.

Or..stick a variable in the session that you change from 0 to 1 or something once the form has been submitted to the database