I have a combobox name cboSearchBy and a textbox named txtSearchString. The user has to first select the field name they want to search by by choosing from the combobox then they can type the string in the textbox. I want to filter it but can't get it!! HELP!
Dim dvView As New DataView()
Dim SearchBy As String
SearchBy = cboSearchBy.Text
.Table = dsProfile.Tables("Profile")
.RowFilter = "'SearchBy' = '" & txtSearchString.text & "'"
dtgProfile.DataSource = dvView
If I did .RowFilter = "Username = 'quilla'" then it filters it.. there's something wrong!