1.11M Members

Need Help :Complex filtering datagridview items

 
0
 

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

 
1
 

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

Question Answered as of 2 Years Ago by Techyon
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article