title: DataView.RowFilter in DataTable does not return filtered records
body: <p>I have a DataTable <strong>dt</strong>, in which 1200 records are coming.
  Below is the code:</p>
  
  <pre><code>DataTable dt = new DataTable();
  dt = GetAccCode(c);
  </code></pre>
  
  <p>Now, using DataView I want to filter the record of <strong>dt</strong>, based on 1 column.
  Below is the code:</p>
  
  <p><strong>EDITED</strong></p>
  
  <pre><code> DataView dv = new DataView(dt);
      dv.RowFilter = "AccountDescription LIKE '" + e.Text + "' " ;
      dv.RowFilter = "Isnull(AccountDescription,'NULL') &lt;&gt; 'NULL'";
  
      //dv.RowStateFilter = DataViewRowState.ModifiedCurrent;  
      if (dv.Count &gt; 0)
      {
          dt = dv.ToTable(); 
      }
  </code></pre>
  
  <p>Full Code: <br/>
  <strong>C# CODE:</strong></p>
  
  <pre><code>private const int ItemsPerRequest = 50;
  
      private static string GetStatusMessage(int offset, int total)
      {
          if (total &lt;= 0)
              return "No matches";
  
          return String.Format("Items &lt;b&gt;1&lt;/b&gt;-&lt;b&gt;{0}&lt;/b&gt; out of &lt;b&gt;{1}&lt;/b&gt;", offset, total);
      }
  
      public DataTable GetTable()
      {
          //  columns.
          DataTable table = new DataTable();
          table.Columns.Add("AccountCodeID", typeof(Guid));
          table.Columns.Add("AccountDescription", typeof(string));
          // DataRows.
          table.Rows.Add(Guid.NewGuid(), "9830.58578 Furniture&amp;Food counter ");
          table.Rows.Add(Guid.NewGuid(), "09.323232 New-release add ons");
          table.Rows.Add(Guid.NewGuid(), "84.238799 G&amp;D - Depot from Outerjoin");
          table.Rows.Add(Guid.NewGuid(), "141.44445043-Random&amp;Access-Memory hydero 048kkjug ");
          table.Rows.Add(Guid.NewGuid(), "142.85223 Account's hyqure");
          table.Rows.Add(Guid.NewGuid(), "324.989384934 F&amp;D Admin-Dept Working ");
          table.Rows.Add(Guid.NewGuid(), "77.234434 Unique's Question why not's so");
          return table;
      }
  
      protected void ddlAccountCode_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
      {
          string c = ddlCompany.SelectedValue.ToString();
  
          DataTable dt = GetTable();
          DataView dv = new DataView(dt);
          string searchParamText = e.Text;
          dv.RowFilter = string.Format("AccountDescription LIKE '%{0}%'", searchParamText);
          //dv.RowStateFilter = DataViewRowState.ModifiedCurrent;
  
          int a = dv.Count;
          if (dv.Count &gt; 0)
          {
              dt = dv.ToTable();
          }
  
          RadComboBox combo = (RadComboBox)sender;
  
          int itemOffset = e.NumberOfItems;
          int endOffset = Math.Min(itemOffset + ItemsPerRequest, dt.Rows.Count);
          e.EndOfItems = endOffset == dt.Rows.Count;
  
          for (int i = itemOffset; i &lt; endOffset; i++)
          {
              combo.Items.Add(new RadComboBoxItem(dt.Rows[i]["AccountDescription"].ToString(), dt.Rows[i]["AccountDescription"].ToString()));
          }
  
          e.Message = GetStatusMessage(endOffset, dt.Rows.Count); 
      }
  </code></pre>
  
  <p><strong>HTML Code:</strong></p>
  
  <pre><code>    &lt;EditItemTemplate&gt;
           &lt;asp:Label ID="lblAcCode2" runat="server" Text='&lt;%# Eval("AccountCode") + " - " + Eval("AccountDescription")%&gt;' Visible="false"&gt; 
           &lt;/asp:Label&gt;
  
           &lt;telerik:RadComboBox ID="ddlAccountCode" runat="server" Height="200" Width="240" DropDownWidth="310" HighlightTemplatedItems="true" CausesValidation="true" OnItemsRequested="ddlAccountCode_ItemsRequested" ItemsPerRequest="10" EnableLoadOnDemand="True" ShowMoreResultsBox="true" EnableVirtualScrolling="true" Filter="Contains" AppendDataBoundItems="true" DataTextField="AccountDescription" DataValueField="AccountCodeID"&gt;
           &lt;/telerik:RadComboBox&gt; 
  
      &lt;/EditItemTemplate&gt;
  </code></pre>
  
  <p>But everytime <strong>dt</strong> returns all 1200 records not the filtered record.</p>
  
  <p><strong>Requirement:</strong> When I click on RadComboBox, it goes into <code>_ItemRequested</code> event. I want that when I search any record in RadComboBox, and if the record is there in DataTable then it shall goto <code>GetStatusMessage</code> ELSE part, or if the searched record is not there in DataTable then it shall goto <code>GetStatusMessage</code> IF part.<br/>
  To get the searched record of RadComboBox from DataTable, I am using DataView.RowFilter method but everytime when I type any text in RadCombo, it never return the searched value and always show DataView.Count =0</p>
  
  <p>Please reply how to solve this issue. I am stuck from 2 days in it.</p>