How to use DISTINCT in dataTable.select method

B

Balu Smiles

Hi All,

can body give solution to this

________________________________________________
Dim oDataRow As DataRow
oTable = oDataset.Tables(0)
Dim objResults() As DataRow
objResults = oTable.Select("DISTINCT objType")
For Each oDataRow In objResults
debug.writeline(((oDataRow("objType")))
Next
________________________________________________

Thanks

BaluSmiles


Thanks
 
R

Rajesh Patel

select method accepts filter condition as 1st parameter if you send any
parameter. I don't think, distinct objType is valid filter condition.

Rajesh Patel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distinct Values from a Datatable 3
Reflection: CreateInstance(Type) of class that supports known interface - Get actual interface refer 10
Memory Leak Caused by Using DataTable.Select 12
ADO.NET: using xml as a database, adding rows to the xmlfile 5
pass regular type to generic method 7
DataTable.select method 1
DataTable.Select FilterExpression with Distinct 0
Raising an Event in a Delegate causes problems 3

Top