How to avoid duplicate entery into datagrid in C#

Question

0.00/5 (No votes)

See more:

Hi Dear,

i am entring data into datagrid from textbox i want to avoid duplicate entry into datagrid. any prompt help will be appreciated.

I am working in windows application.

Best Regards,
Aftab

Posted 24-Apr-11 21:06pm

Member 7869581

Add a Solution

2 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-04-24T21:38:00

Solution 2

If possible, try to put some logic in your query or collection / datasource that holds this data - it might be easier.

Posted 24-Apr-11 21:38pm

Abhinav S

Comments

[no name] 25-Apr-11 3:43am

I 100% agreed, actually I do not prefer to implement any data manipulation logic from the GUI end.

Tarun.K.S 25-Apr-11 3:48am

How about using HashSet?

Abhinav S 25-Apr-11 3:53am

Could be done - but some care needs to be taken to ensure that keys dont duplicate right? At least the error handling should be proper.

Tarun.K.S 25-Apr-11 4:04am

Yep true. But I was thinking that, if there are hundreds or lets say thousands of items, then looping through all and checking for duplicates can be expensive. But I guess that might be the only way to check.

anshudutta · Answer 2 · 2011-04-24T21:31:00

Bind the datagrid with a data table and make the column as unique / primary key. This will create a constraint in the table which will prevent it from adding duplicate values

see sample code for unique key from msdn

DataTable custTable = custDS.Tables["Customers"];
UniqueConstraint custUnique = new UniqueConstraint(new DataColumn[]
{custTable.Columns["CustomerID"],
custTable.Columns["CompanyName"]});
custDS.Tables["Customers"].Constraints.Add(custUnique);