c# - How to filter DataView based on multiple inputs

Question

I know how to filter data based on the user's input from a single textbox:

FilterDataView.RowFilter = txtFilter.Text;

But how would you go about filtering data based on multiple user input from multiple fields. Basically filter would act as a "search" functionality.

Answer 1

You can use something like light t-sql when defining RowFilter.

One idea is:

FilterDataView.RowFilter = "name like '%habjan%' and city like '%new york%'"

Here you can find a good article about RowFilter syntax: DataView RowFilter Syntax

For what you need you will have to build row filter based on entered fields.

    StringBuilder sb = new StringBuilder();

    if (tb1.Text.Length > 0)
    {
       sb.Append("name like '%" + tb1.Text + "%'");
    }

    if (tb2.Text.Length > 0)
    {
       if(sb.Length > 0)
       {
           sb.Append(" and ");
       }

       sb.Append("city like '%" + tb2.Text + "%'");
    }
    //.... and so on...

    FilterDataView.RowFilter = sb.ToString();