Debug your program and check what
rowFilter
returns. Seems you missed
''
around the text returned by
childnote.Text
. It should be something like
"FieldName = 'Some Text'"
For further information, please see:
DataView.RowFilter Property [
^]
DataView RowFilter Syntax [C#][
^]
Several time on this forum was mentioned that string is immutable. What to do? Please, read this:
Why strings are immutable and what are the implications of it?[
^]
[EDIT]
DataView class[
^] enables filtering, but some criteria must be fulfilled, see:
DataColumn.Expression[
^] and
Sorting and Filtering Data[
^]
So, based on the images you posted in comment,
Yes
or
No
value is used for
Grant
column, then
rowFilter = "Grant='Yes'";
If you want to add several condtions, use:
rowFilter = "(Grant='Yes') AND (AreaCode = 11 OR AreaCode = 31) AND (Land='North' OR Land='Schweiz')";
Try!