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...

is there any way ?
can i do it?

Thx for Answers :)

Recommended Answers

All 2 Replies

Something like this?

I presume you are connecting a DB of some sort.

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
'poplate gridview
    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

thx for techyon to help :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.