Member Avatar for Oneryavuz

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 :)

Edited by Oneryavuz because: n/a
  • 2 Contributors
  • 2 Replies
  • 108 Views
  • 10 Months Discussion Span
  • Latest Post Latest Post by Oneryavuz

Recommended Answers

All 2 Replies

Member Avatar for Techyon

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
next
Member Avatar for Oneryavuz 
    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, networking, learning, and sharing knowledge.