i wanna search items like MS windows search for example if i wanna search mp4 files i should write "*.mp4" its enough my searching but if i ll use filter function i cant do this on datagridview couse when i want to search something i need to know full name of this record... its to bad for me...
Dim ds As New DataSet
'oData is just an interface which contains my connection strings
ds = oData.GetSQL("SELECT * FROM [TableName] WHERE " & cbFilter.Text & " LIKE '%" & txtSearch.Text & "%'"
For Each dr As DataRow In ds.Tables(0).Rows
Dim dv As New DataView(DbDataSet.Tables("Table1"))
dv.RowFilter = "Column1 Like '" & TB_Anything.Text & "%' OR column2 Like '" & TB_Arama.Text & "%' "
''the most important think is % operator its like search on windows "*.avi" %=*
DataGridView1.DataSource = dv '' so u can see your filtred results