How to prevent duplicate data in the grid view?

Question

I have a grid view and this grid view has a DataKeyNames="person_id"

Now I want this key as a primary key for the grid so no allowed duplicates .

How to prevent duplicate data through using DataKeyNames

This isn't how DataKeyNames works. If you want to prevent duplicates you have to make sure your data source doesn't return duplicate records. — Sean Airey, Nov 14 '12 at 14:28

score 4 · Accepted Answer · answered Nov 14 '12 at 14:25

4

GridView is a presentation layer. It should not do any validation. I suggest you to check for duplicates in Data Access layer.

answered Nov 14 '12 at 14:25

Uriil

11,948
11
47
68

score 1 · Answer 2 · answered Nov 14 '12 at 14:26

The DataKeyNames can contain duplicate values so you will need to ensure that your data source does not have duplicates for that field. If it does, you can programmatically loop through your grid view after it has bound and manually remove duplicate rows by adding some logic in the code-behind.

score 1 · Answer 3 · answered Nov 14 '12 at 14:28

1

You need to distinct result, from datasource. If you are using SQL query, check it http://www.w3schools.com/sql/sql_distinct.asp . In case you are using LINQ - .Distinct() .

answered Nov 14 '12 at 14:28

Ivan Spahiyski

86
2

How to prevent duplicate data in the grid view?

3 Answers3