vb.net - Filtering Bindingsource using 2 textbox -

im using visual studio 10, programming in vb, using oracle database. need filter on datagridview 2 variables. code far looks this:

tablebindingsource1.filter = "[field1] = '" & textbox1.text & "'" datagridview1.refresh() 

how can insert field2 , textbox2 in example, making both filters working together? lot.

something maybe:

me.bindingsource.filter = "field1= '" & txt1.text & "' , field2 >= " & txt2.text 

'example

       ' dataview of table contained in dataset.    dim tables datatablecollection = set1.tables   dim view1 new dataview(tables(0))  ' create datagridview control , add form.    dim datagridview1 new datagridview()   datagridview1.autogeneratecolumns = true   me.controls.add(datagridview1)  ' create bindingsource , set datasource property ' dataview.   dim source1 new bindingsource()   source1.datasource = view1  ' set data source datagridview. datagridview1.datasource = source1  ' filter string can include boolean expressions. source1.filter = "artist = 'dave matthews' or cd = 'tigerlily'" 

source1

source2

msdn