RowFilter

I am trying to filter my record base on Employee No. like this;

Dim aFind As String
aFind = InputBox("Enter a Employee No.", "Search for Employee No.")
Dim dv As DataView = DataSet11.Employee.DefaultView
dv.RowFilter = "empno='" & aFind & "'"

But it has no reaction and it not working. Kindly teach me the correct syntax of RowFilter?

VB Code:

Dim aFind As String= InputBox("Enter a Employee No.", "Search for Employee No.") 
Dim filteredRows() As DataRow = DataSet11.Employee.Select("empno='" & aFind & "'")
'now filteredRows contains any rows that match the critieria

Omit those ' from your filter string when you are filtering on numbers not text. So your code is correct except it should be like this:

VB Code:

dv.RowFilter = "empno=" & aFind

I dont get it where to you use the filteredrows() at then?

in the above example filteredrows() is an array of DataRows containing the desired criteria.