asked on

inserting non duplicate data

hi all,

I have an asp.net page in which users insert data to the database. my question is that how can i search if the data is a duplicate and if so show a message that says that the data is already in the db. if not just insert the data and show a message that says it is successfully enterd

thanks

mrichmon

One way to do this is to have a primary key in the database or a constraint on the table. Just try to do the insert and catch the constraint violation, if you see that then you can display the message that the data is already entered, otherwise it will have inserted.

topdog770

Generally speaking:

1. compare it to a local dataset of data that matches the data in the database

2. do a query against the database to see if values user wants to add already exist

3. put constraints on the database that don't allow duplicate data, which will cause the insert to fail. By catching the exeception, you would then know the data already exists.

ASKER CERTIFIED SOLUTION

sridon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jemigossaye

ASKER

hi sirdon,
how can i count the executescalar()
what i am doing now is trying to cast it to an int and assign it to an int var
and then with in if else i am will try to insert it

thanks

sridon

hi jemigossaye,

Yep that is the way you have to do it. Type cast it to an int and then check the value of the int.