DataTable Filter Expresion Question?

Hi,

I have a datatable and I would like to filter it as follows:

For Each row As DataRow In odds.Select("OutComeGameDesc = ' FINAL RESULT ' OR OutComeGameDesc = ' Oyun Nticsi ' AND OutComeGame IN ( ' 1 ',' X ',' 2 ')")

But there is something wrong with the OR filter and returning result is wrong. This OutComeGameDesc column can be "FINAL RESULT" or "Oyun Nticsi".

How can I achieve this?

By the way, can I use MAX and MIN for a specific column also?

Best Regards.

Re: DataTable Filter Expresion Question?

Is your column have values having leading and trailing spaces like ' FINAL RESULT ' ,if not then try to use it as

For Each row As DataRow In odds.Select("OutComeGameDesc = 'FINAL RESULT' OR OutComeGameDesc = 'Oyun Nticsi' AND OutComeGame IN ( '1','X','2')")

Re: DataTable Filter Expresion Question?

Hi,

It has spaces.

Re: DataTable Filter Expresion Question?

try this

odds.Select("(OutComeGameDesc = ' FINAL RESULT ' OR OutComeGameDesc = ' Oyun Nticsi ') AND OutComeGame IN ( ' 1 ',' X ',' 2 ')");