a problem with filtering (Dataview.RowFilter)

[CLRBOY]

Greetings,

how do I filter the rows in the same dataview with more then one variable to filter ?

when I do this one after another it doesnt work....

myDataView.RowFilter = "ID = " + hmnID + "";
myDataView.RowFilter = "the_name = " + the_name + "";

CLRBOY

 

[Optikal]

myDataView.RowFilter = "ID = " + hmnID + " AND the_name = " + the_name + "";

 

[CLRBOY]

myDataView.RowFilter = "ID = " + hmnID + " AND the_name = " + the_name + "";

thanks!!!!