how to get distinct values from a data table 1

[chinnijahn]

I am using vb 2005 and dotnet version 2.0

Hi I have a data table called Details.
I have created a binding source called bsr_details

Details have field names like plant , options..

i want to get the disticnt values of all options..

if i have to write it in sql then i could have write

"select distinct options from details where plant = 1"

I am not allwoed to access teh database here so I have to use the table adapter and binding source ..so please guide me how to get those desired results...

 

[TipGiver]

I thing this should be OK

Dim colNames() As String = {"options"}
Dim DistinctOnOptions As DataTable = Details.DefaultView.ToTable(True, colNames)

 

[chinnijahn]

Hi The above solution actually worked however I had table adapter instead of a datatable.

so I have used Getdata method of the table adapter to get the data table.

The code looks like this

Dim colnames() As String = {"Order"}

Dim tdistinctRows As DataTable = TestTableAdapter.GetData(JobNo, MixNo, nothing, Nothing)

tdistinctRows = tdistinctRows.DefaultView.ToTable(True, colnames)

and i had the desired result...

Thanks a lot Tip Giver for helping me in this...

 

[TipGiver]

Glad to help and also thanks for your *