Checking database for records before Insertion
Posted on 2005-04-27
Here is what im trying to do in a nut shell(Using VB.NET):
1. Insert a new customer record into the database.
2. If that new record already exist, then display a warning message for the user stating:
"Customer already exist in system".
3. Based on 1 and 2 above, my end result should be one of the following:
Sucessfully insert new customer record. Then display a sucess message:
"The customer has been added!"
Display a warning message about the customer already being in the database:
"Customer already exist in system!"
I hope this is clear.
Thanks everyone for your help!