title: Filtering DataView with multiple columns
body: <p>In my application I am using a dataview for having the filters to be applied where the filter options are passed dynamically.if there are 2 filter parameters then the dataview should be filtered for parameter1 and then by parameter two. I am using a method which is called in a for loop where I am setting the count to the total no.of parameters selected using a listbox but the filtering is done only for the last parameter.
  Here is my code:</p>
  
  <pre><code>string str = "";
  for (int i = 0; i &lt; listbox.Items.Count; i++)
  {
      if (listbox.Items[i].Selected)
      {
          if (str != string.Empty)
          {
              str = str + "," + listbox.Items[i].Text;
  
          }
          else
          {
              str = str + listbox.Items[i].Text;
          }
      }
  }
  
  string[] items = str.Split(',');
  for (int i = 0; i &lt; items.Length; i++)
  {
      ApplyFilter(items[i],dv);
  }
  
  private DataView ApplyFilter(string str,DataView newdv)
  {
      newdv.RowFilter = "[" + str + "]=" + ddl.SelectedItem.ToString();
  
      return newdv;
  }
  </code></pre>
  
  <p>Please provide a suitable solution .</p>
  
  <p>Thanks in advance...</p>