using distinct in datatable

  • Thread starter Thread starter Patrick.O.Ige
  • Start date Start date
P

Patrick.O.Ige

I'm trying to do distinct below in a datatable
but i get the error :-
Syntax error: Missing operand after 'Code' operator.
Any ideas?

string strExpr = "DISTINCT Code LIKE '%ve%'" ;
DataRow[] XmlRow = myTable.Select(strExpr);
 
I not sure you can use DISTINCT in like that. The string param in Select()
is strickly a Where clause. I think you're going to have to remove the
DISTINCT.

Tony
 
Back
Top