Remove Duplicate Rows from Gridview

Question

1.00/5 (1 vote)

See more:

Hello everyone ,

My sql table has some duplicate item like this :

id-- item_id -- user_name -- basket

1 1 - John - Empty
2 1 - John - order_1
3 2 - Mike - order_2
4 2 - Mike - order_3
5 2 - Mike - order_4
6 3 - Daniel - order_5
7 4 - Simon - order_6
8 4 - Simon - order_7
9 5 - Jane - order_8

when i take this data from sql to gridview , want to delete dublicate items in item id

my gridview should be like this :

id-- item_id -- user_name

1 1 - John
3 2 - Mike
6 3 - Daniel
7 4 - Simon
9 5 - Jane

How can i do this ?

I saw this post :

[^]

But in this post gridview has some empty cells , i don't want to see any empty cells.

Thank you.

Posted 21-Oct-15 9:25am

kozmikadam

Updated 14-Jul-20 21:25pm

Add a Solution

Comments

Sergey Alexandrovich Kryukov 21-Oct-15 15:55pm

I wonder, why not preventing creation of duplicate rows in first place?
—SA

[no name] 21-Oct-15 15:58pm

From my Point of view you don't Need to remove duplicates from gridview, you should correct your logic!

The list of the result vs. data in table makes not a lot of sense, at least for me....

a.) Make sure your DB contains data which are useful
b.) Select the correct data from DB

3 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)

ZurdoDev · Answer 1 · 2015-10-21T10:13:00

Solution 1

This is not a gridview problem but a sql problem. Either your join is not correct or you have bad data. You'll want to fix it in SQL.

Posted 21-Oct-15 10:13am

ZurdoDev

Comments

[no name] 21-Oct-15 16:48pm

I agree, a 5.

kozmikadam 22-Oct-15 1:20am

It's not my db. So we have a lot of data in this db , and i am trying to get this data from there. So I'm looking for a solution. I can't create a new db, i haven't any permissions for this.

ZurdoDev 22-Oct-15 7:05am

So fix your SELECT statement.

Andre Oosthuizen · Answer 2 · 2020-07-14T21:25:00

Solution 3

I agree with Zurdodev's answer, change your sql statement to load data/populate the grid with the correct returned data excluding the duplicates by using the SQL SELECT DISTINCT Statement -

SQL

SELECT DISTINCT user_name
  FROM my_table
ORDER BY id

Posted 14-Jul-20 21:25pm

Andre Oosthuizen

v2

Comments

CHill60 15-Jul-20 5:00am

I'm going to counter the 1-vote as you've provided the actual means to fix the SQL statement - I suspect the downvote was because the question is 5 years old

Andre Oosthuizen 15-Jul-20 5:27am

Oh my gosh, I never saw the date of the post, just the time stamp on the last post as it popped up at the top under unanswered questions, my bad. Thank you very much for the positive return, I should have checked tsk tsk!

Mirza_Mehran · Answer 3 · 2020-07-14T11:46:00

Remove All Duplicate Rows from DataGridview
{
if (dataGridView1.Rows.Count >= 0)
{

for (int currentRow = 0; currentRow < dataGridView1.Rows.Count; currentRow++)
{
var rowToCompare = dataGridView1.Rows[currentRow]; // Get row to compare against other rows

// Iterate through all rows
//
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (rowToCompare.Equals(row))
{
continue;
}
// If row is the same row being compared, skip.

bool duplicateRow = true;

// Compare the value of all cells
if (rowToCompare.Cells[0].Value != null &&
rowToCompare.Cells[0].Value.ToString() != row.Cells[0].Value.ToString())
{
duplicateRow = false;

}

if (duplicateRow)
{
dataGridView1.Rows.RemoveAt(row.Index);
break;
}
}
}
}
}
catch
{
}

Remove Duplicate Rows from Gridview

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us