how to filter distinct row from DataView

[krishnaveer]

I have the following line of code (.NET 2.0): myDataView.RowFilter = "SELECT DISTINCT Auto"; where Auto is one of my column names. This throws the following exception: Syntax error: Missing operand after 'DISTINCT' operator. Any suggestions on what this is really trying to tell me?

krishna veer singh

[Satish Mahapatra]

write like select distinct(auto)

[Abhishek Sur]

for distinct use myDataView = myDataView.ToTable(true,"ColName").DefaultView; :rose::rose::rose:

Abhishek Sur

[krishnaveer]

I try but its not working....

krishna veer singh

[N a v a n e e t h]

You can't have SQL statements in RowFilter expression. Please read[^] the documentation. :)

Navaneeth How to use google | Ask smart questions