title: How to use Telerik RadGrid FilterExpression on DataTable programmatically
body: <p>I have 2 pages 1 with Telerik RadGrid another with Telerik RadChart thay use the same DataTable. When I filtered RadGrid on the page I want to press the button and have the RadChart update to use the same filtered DataTable.</p>
  
  <p>So first of all, here's what I've already tried.</p>
  
  <p>With LINQ expressions turned off(<code>EnableLinqExpressions="false"</code>), I can set the RadGrid filter expression (for example) as follows:</p>
  
  <pre><code>Grid.MasterTableView.FilterExpression = "([Date] LIKE '%21%')"
  </code></pre>
  
  <p>And now I can use:</p>
  
  <pre><code>private void SetFiltring(ref DataTable table)
  {
      table = table.Select("([Date] LIKE '%21%')", "").CopyToDataTable();
  }
  </code></pre>
  
  <p>Its work great.</p>
  
  <p>Now if I want to use LINQ expressions turned on(<code>EnableLinqExpressions="true"</code>)
  I can set the RadGrid filter expression (for example) as follows:</p>
  
  <pre><code>Grid.MasterTableView.FilterExpression = "it["Date"].ToString().ToUpper().Contains("21".ToUpper()))"
  </code></pre>
  
  <p>And now i dont know how to use this FilterExpression on DataTable . How can  use this FilterExpression on DataTable.And Will Linq be faster than MSSQL Server syntax?</p>