1,105,423 Community Members

Need Help :Complex filtering datagridview items

Member Avatar
Oneryavuz
Junior Poster in Training
70 posts since Jul 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 3 [?]
Skill Endorsements: 0 [?]
 
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 :)

Member Avatar
Techyon
Newbie Poster
23 posts since Apr 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 3 [?]
Skill Endorsements: 0 [?]
 
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
Member Avatar
Oneryavuz
Junior Poster in Training
70 posts since Jul 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 3 [?]
Skill Endorsements: 0 [?]
 
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 1 Year Ago by Techyon
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article