how to add combobox selected text and textbox to rowfilter

Question

0.00/5 (No votes)

See more:

Win2008

hi i have a datagrid view which i need to filter based on search textbox and one combo box when i select the column from the combobox (there are 12 columns in my table) and click button the filtered items should display. my problem is like i can hardcore like below this code works only for that particular column not for the other columns

C#

table.DefaultView.RowFilter = "USER_NAME='" + txtSearch.Text + "'";

it displays for only one column how should i do the code for all tweleve columns ?????

someone pls help me

Posted 23-May-12 20:11pm

Member 8983639

Updated 23-May-12 20:22pm

Mohamed Mitwalli

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-05-23T20:45:00

Solution 1

You can specify multiple conditions in the RowFilter. You can form the expression which is quite similar to SQL.

Details here:
MSDN: DataColumn.Expression Property [^]
MSDN: DataView.RowFilter Property[^]

Sample:

C#

myDataView.RowFilter = "Name = 'Sandeep' AND JoinDate > '1/1/2010'";

Posted 23-May-12 20:45pm

Sandeep Mewara

Comments

Member 8983639 24-May-12 5:45am

ythanks alot

Sandeep Mewara 24-May-12 5:56am

Welcome.

how to add combobox selected text and textbox to rowfilter

1 solution

Solution 1

Add your solution here

Preview 0

how to add combobox selected text and textbox to rowfilter

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us