How to remove duplicate value from datagridview using winform C#

Question

0.00/5 (No votes)

See more:

I have a DataGridView. It is containing Two Columns which is

EMPId    |   DATEtiME
1        |   2019-04-20 07:30:00.000
1        |   2019-04-20 12:30:00.000
1        |   2019-04-20 13:00:00.000
2        |   2019-04-20 07:30:00.000
2        |   2019-04-20 07:30:00.000
2        |   2019-04-20 13:00:00.000
3        |   2019-04-20 07:30:00.000
3        |   2019-04-20 12:30:00.000

I want to remove second row value in EMPID 1 and I want to remove second value in EMPID 2 and EMPID will remain the same. Like.

EMPId    |   DATEtiME
1        |   2019-04-20 07:30:00.000
1        |   2019-04-20 13:00:00.000
2        |   2019-04-20 07:30:00.000
2        |   2019-04-20 13:00:00.000
3        |   2019-04-20 07:30:00.000
3        |   2019-04-20 12:30:00.000

Please help anyone

What I have tried:

..................................................................................................................

Posted 20-Apr-19 3:20am

Member 12245539

Updated 20-Apr-19 5:14am

Add a Solution

Comments

[no name] 20-Apr-19 9:27am

a.) I don't see the logic in your example, especially for EMPId == '1'.
b.) Assuming the data comes from a database think about SELECT DISTINCT

Member 12245539 20-Apr-19 9:36am

For EMPID 1, in same date it has three entries such as 07.30, 12.30 and 13.00. Now I want keep only 1 entry and last entry...

[no name] 20-Apr-19 9:43am

In other words: You like to show only first and last according to date for a given EMPId?

Member 12245539 20-Apr-19 9:47am

Yes

[no name] 20-Apr-19 9:49am

And the data comes from database which can be queried by SQL?

Member 12245539 20-Apr-19 9:52am

SQL Server

[no name] 20-Apr-19 9:59am

Id did not read it carefully but it looks like it could help you:https://www.codeproject.com/Questions/636953/To-find-the-first-and-last-records-in-a-given-tabl[^]

Member 12245539 20-Apr-19 9:54am

This data comes from SQL server

BillWoodruff 20-Apr-19 10:11am

show the code you have tried ! do you want to change the data in the database, or, do you only want to change the data shown in the UI ?

Member 12245539 20-Apr-19 10:20am

Only want to change in UI..

BillWoodruff 20-Apr-19 11:19am

So: edit your question, and show how you now get the data from the database into the DataGridView. Describe what you have learned about how to filter data. Start here:

https://www.google.com/search?ei=4Te7XLrDIpC-9QPDjZq4BQ&q=c%23+filter+data+displayed+in+datagridview

2 solutions

Solution 1

Select and group on the "duplicate columns / fields".

GROUP BY EMPID, DateTime.

Posted 20-Apr-19 4:24am

Gerry Schmitz

Updated 20-Apr-19 4:26am

v2

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)

User 11060979 · Accepted Answer · 2019-04-20T05:14:00

Please note: I'm not sure whether this is an elegant solution and more whether this can become a performance bottle neck. But at least it looks like it works.

a.) Create test table

CREATE TABLE Tbl
(
	EMPId integer,
	DATEtiME DateTime
);

b.) Insert Test data

INSERT INTO Tbl(EMPId, DATEtiME)
VALUES(1, '2019-04-20 07:30:00.000'),
(1, '2019-04-20 07:30:00.000'),
(1, '2019-04-20 12:30:00.000'),
(1, '2019-04-20 13:00:00.000'),
(2, '2019-04-20 07:30:00.000'),
(2, '2019-04-20 07:30:00.000'),
(2, ' 2019-04-20 13:00:00.000'),
(3, '2019-04-20 07:30:00.000'),
(3, '2019-04-20 12:30:00.000'),
(4, '2019-04-20 00:30:00.000')

c.) Test query

SELECT DISTINCT
	a.EMPId, 
	a.DATEtiME
FROM Tbl a
WHERE a.DATEtiME IN (SELECT MIN(minEmp.DATEtiME) FROM Tbl minEmp WHERE minEmp.EMPId = a.EMPId)
   OR  a.DATEtiME IN (SELECT MAX(maxEmp.DATEtiME) FROM Tbl maxEmp WHERE maxEmp.EMPId = a.EMPId)

d.) Result

1	2019-04-20 07:30:00.000
1	2019-04-20 13:00:00.000
2	2019-04-20 07:30:00.000
2	2019-04-20 13:00:00.000
3	2019-04-20 07:30:00.000
3	2019-04-20 12:30:00.000
4	2019-04-20 00:30:00.000

Most probably the SQL experts @CHill60 and @losmac can give you a better answer ;)