C# compare two datagridviews and remove duplicate values with match only 3 columns to see the duplicate

1.00/5 (1 vote)

See more:

I have two datagridviews as 1 and 2, I just need to compare the two datagridviews and remove duplicate values from datagridview 1 with match only 3 columns in two datagridviews (no need to read all the column values in single row, only specific columns to check the duplicate) to see the duplicate. Please support me.

Posted 17-Nov-14 8:36am

abdulsafran

Add a Solution

Comments

ZurdoDev 17-Nov-14 14:40pm

Where are you stuck?

abdulsafran 17-Nov-14 14:47pm

Hi RyanDev, Thank you for the reply. I could't able to start since I just want to compare 3 columns in both datagridviews and remove need to done in only datagridview 1, I know how to select and remove data, but when it's come to large data, we couldn't able to do it manually, waiting for your support with sample coding.

int n1 = dataGridView2.CurrentCell.RowIndex;
dataGridView2.Rows.Remove(dataGridView2.Rows[n1]);

ZurdoDev 17-Nov-14 14:51pm

Don't you just want to loop through the rows and if they don't match, remove them?

abdulsafran 17-Nov-14 14:54pm

RyanDev, Datagridview2 have first column as checkbox and datagridview2 does not have checkbox, other columns are same. So how to match the full row?

ZurdoDev 17-Nov-14 15:00pm

You just have to write code to do it.

Compare each column from each table.

abdulsafran 17-Nov-14 15:05pm

Ok RyanDev, I'll try my best.

Kornfeld Eliyahu Peter 17-Nov-14 14:44pm

What is the source of the data displayed in the DataGridView?

abdulsafran 17-Nov-14 14:50pm

Hi Kornfeld, Thank you for your reply. datagridview1 source from database and datagridview2 is transferred values from datagridview1. Datagridview2 have first column as checkbox and datagridview2 does not have checkbox, other columns are same.

BillWoodruff 17-Nov-14 14:52pm

Is it the case that at some point in time the two DataGridViews were both bound to the same DataSource, and changes in one changed the value in the other ?

I would guess it would be too expensive in terms of computation and memory to operate on only on DataGridView1's DataSource, and then essentially refresh DataGridView1 ?

abdulsafran 17-Nov-14 14:56pm

Hi Bill, thank you for your reply. I couldn't able to get your point.

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

Last 24hrs

This month

Rick York	90
OriginalGriff	60
Pete O'Hanlon	40
Test Mail May2023	20
Dave Kreskowiak	10

Pete O'Hanlon	1,860
OriginalGriff	1,395
Graeme_Grant	895
Richard Deeming	808
Dave Kreskowiak	694

C# compare two datagridviews and remove duplicate values with match only 3 columns to see the duplicate

Add your solution here

Preview 0

C# compare two datagridviews and remove duplicate values with match only 3 columns to see the duplicate

Add your solution here

Preview 0

Existing Members

...or Join us