Re: Avoid inserting a duplicate record on page submit?

Tech-Archive recommends: Speed Up your PC by fixing your registry

I Agree 100% with Dale.
It's a common knowledge to add a primary key in your database table; by
chance perhaps even unique constraints for certain non-key columns.
A good practice is to implement a procedure that inserts records and
the procedure should be inside a SQL TRY CATCH that returns back a user
friendly error that the data already exists.
You cannot rely aalone on the asp.net interface to validate your data.
But even though u don't want to touch that, cosider the Postback in
ASP.NET.

.

Relevant Pages

  • Re: Budapest defence
    ... I checked a database of 3.6 million games using the free chess database ChessDB and find the following number of occurrences, ... indicating there is a 50.7% probability that the same or smaller difference occurs by chance. ... 'Experts Exchange' take questions posted on the web and try to find ...
    (rec.games.chess.analysis)
  • Re: Discovery of unique constraints using Catalog Methods
    ... > I suspect it makes sense for any unique constraints in any database ... > products to have implied indexes, since an index is required to ... uses multiple catalog tables to record the unique constraint, ... I agree this isn't a good candidate for DBI - the database functionality ...
    (perl.dbi.users)
  • Re: Math.random() algorithm
    ... I just find it odd that a society would think that random numbers, that have a probability of repeating - no matter how small that chance - is better than a system where the chance of repeating a number is impossible. ... If you want a 16 digit patient ID, you create a database with those ID'es. ...
    (comp.lang.javascript)
  • AW: Root Space Full
    ... My suspician is that the database 'prod_db' was created in ... Then recreate the unique constraints. ... in a dbspace which is not the rootdbs. ...
    (comp.databases.informix)
  • Re: GATSO 2: The revenge of GATSO.Pt2 - LONG
    ... >>> Can you offer an alternative solution that stands some chance of ... >>> course that any database should be up to date and accurate. ... I am shocked Mark imagines there could be. ...
    (uk.rec.driving)