Question Select Distinct record from datatable

[prasad kulkarni]

hello,

In my Data table there are 10 records , 5 records are duplicate (repeat),
I want to select distinct record from data table , condition on data table
to select distinct record . so in my data table only 5 record are there.

if any know, reply me soon

 

[Satal Keto]

You need to look at the DISTINCT SQL command.

The following websites should give you all the information you require
SQL DISTINCT
SQL SELECT DISTINCT Statement

Hope this helps

Satal

UPDATE:
BTW this should probably have been posted in Database General Discussion

 

[cjard]

You need to look at the DISTINCT SQL command.

He asked about datatables, not database tables

I want to select distinct record from data table

I'd make another datatable, add a primary key to it, and then insert the rows into it one by one, ignoring any duplicate key exceptions

 

[jmcilhinney]

There is no inbuilt way to get distinct records from a DataTable in .NET 2.0 other than the brute force approach of looping through them and testing each one. In .NET 3.5 you can use LINQ to DataSet to get distinct rows with a single LINQ query.