Filter duplicate rows from datatable

Question

0.00/5 (No votes)

See more:

i got datatable WITH ONLY 1 COLUMN
say

companyname
A
B
C
A
D
B

Now i want to get a distinct count from that datatable

Pls help..

Posted 13-Oct-11 20:26pm

Rakesh S S

Updated 13-Oct-11 20:28pm

Mehdi Gholam

v2

Add a Solution

5 solutions

Add a Solution

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

Mehdi Gholam · Answer 1 · 2011-10-13T20:30:00

Solution 1

Use the following query:

SQL

select count(companyname), companyname from tablename group by companyname

Posted 13-Oct-11 20:30pm

Mehdi Gholam

Comments

Pravin Patil, Mumbai 14-Oct-11 2:41am

+5 correct answer..

Mehdi Gholam 14-Oct-11 2:42am

Thanks

kishorekke · Answer 2 · 2011-10-13T20:32:00

Solution 2

use like below

SQL

SELECT DISTINCT companyname from TABLE

SQL

SELECT  COUNT(DISTINCT companyname) from TABLE

Posted 13-Oct-11 20:32pm

kishorekke

Updated 13-Oct-11 20:40pm

v2

devildx2050 · Answer 3 · 2011-10-13T20:35:00

Solution 3

SQL

select distinct companyname from tablename

Posted 13-Oct-11 20:35pm

devildx2050

Updated 13-Oct-11 20:41pm

v2

Rakesh S S · Answer 4 · 2011-10-13T21:25:00

Solution 4

I am Talking abt data table

i got it

Dim distinctTable As DataTable = table11.DefaultView.ToTable("DistinctTable", True, "Name")

Posted 13-Oct-11 21:25pm

Rakesh S S

Updated 13-Oct-11 23:17pm

v3

Comments

hitech_s 14-Oct-11 5:17am

bold is not clear in heavy bright ness monitors so i edited that

Anuja Pawar Indore · Answer 5 · 2011-10-13T23:25:00

Solution 5

refer this thread
http://stackoverflow.com/questions/1276150/asp-net-filter-unique-rows-from-data-table[^]

Posted 13-Oct-11 23:25pm

Anuja Pawar Indore

Filter duplicate rows from datatable

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Filter duplicate rows from datatable

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us