I want to filter datagridview. I have one textbox. When I enter value in that textbox datagridview should automatically get filter as per text in textbox.. I load data in datagridview by using following code:
i = 0
rs.Open("select * from prtydtl where gkhass is not null ORDER BY prtynm ASC ", con, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
While Not rs.EOF
prtygridview.RowCount = prtygridview.RowCount + 1
prtygridview.Item(1, i).Value = rs.Fields("prtynm").Value
i = i + 1
rs.MoveNext()
End While
rs.Close()
I don't want it by binding method...
I want to filter the list that s displayed on screen