how to filter distinct row from DataView
-
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
-
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
for distinct use myDataView = myDataView.ToTable(true,"ColName").DefaultView; :rose::rose::rose:
Abhishek Sur
-
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
write like select distinct(auto)
-
write like select distinct(auto)
I try but its not working....
krishna veer singh
-
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
You can't have SQL statements in RowFilter expression. Please read[^] the documentation. :)
Navaneeth How to use google | Ask smart questions