insert query, same data not want in table.

Question

0.00/5 (No votes)

See more:

VB

hi folks,

when i insert data,
if the same data is in the table then i want error msg.
how can i do these.

Posted 14-Feb-11 15:16pm

Bhatt Aniruddh

Add a Solution

Comments

Venkatesh Mookkan 14-Feb-11 21:21pm

You question is too vanilla. You should mention what you did and where you are having the problem.

[no name] 15-Feb-11 0:39am

Please be specific what is your requirement?

Ashishmau 15-Feb-11 4:09am

If u have primary key column...then simple use try catch and write youe error message.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2011-02-14T17:00:00

It really depends upon what you consider 'duplicate' data.

If you have just one field that should not be a duplicate what you need to do is to set that field as a primary key.

If you have two or three fields like this, create a composite primary key.

Then when you try to enter duplicate values. the database will automatically generate error messages.

Yusuf · Answer 2 · 2011-02-14T15:55:00

Solution 1

You need to handle that on your own. Before you insert the data, query if exact data exist, if you found a match then you need to return an error, else you are good to insert the data.

Posted 14-Feb-11 15:55pm

Yusuf

Praveen Kumar Upadhyay · Answer 3 · 2011-02-14T21:56:00

Solution 3

till what I understood from your problem, is u don't want duplicate entry in your table.

If so then use unique constraint on a column.

Posted 14-Feb-11 21:56pm

Praveen Kumar Upadhyay

nomi khan · Answer 4 · 2011-02-14T23:21:00

You can either handle it from back-end or front-end. Let suppose you wanna do it from fron-end then before inserting data, you can check for duplicate records. In order to compare values, one possible way is to get data from database in a DataSet, create a DataView, insert data from DataSet to DataView object, and apply .RowFilter property of DataView. Now your DataView has filtered data. Get this filtered data in any variables and now you can compare it with your values.

Hope it will work.

insert query, same data not want in table.

4 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0