Any way to make DataView to filter for more than one column?

[HAN(removethis)twister]

Is there a way to make a DataView Row Filter filter for more than one
column? Thanks!

 

[Dominique Vandensteen]

you can use AND, OR, and NOT as boolean operators
"columnName1 LIKE '...' AND columnName2 LIKE '...'"

dominique

 

[HAN(removethis)twister]

you can use AND, OR, and NOT as boolean operators
"columnName1 LIKE '...' AND columnName2 LIKE '...'"

dominique

Thank you!

 

[Jay B. Harlow [MVP - Outlook]]

Han,
In addition to Dominique's comments about using AND.

The only place I know of where the syntax that expressions (such as
RowFilter) in the DataSet OM is documented is the DataColumn.Expression help
topic:

http://msdn.microsoft.com/library/d...fSystemDataDataColumnClassExpressionTopic.asp

Hope this helps
Jay

 

[Dominique Vandensteen]

maybe you got it from there (i did), the rowfilter property in dataview
refers to that document...