title: Set DataView (or DataTable.DefaultView) RowFilter for a custom type
body: <p>I'm developing an application on the datagridview filtering. I'm using RowFilter property of the dataview for the filtering data. My database table contains int &amp; varchar data type fields. And I want to use "LIKE" query in the RowFilter Property for filtering the dataview but the "LIKE" is used only for the string data type and not for int data type. So I want to convert the <code>int</code> datatype field to the <code>varchar</code> datatype, but I don't want to alter my table structure. I just want the datatype to be changed temporary for my filtering condition only.</p>
  
  <p>Can anybody help me in resolving this problem?</p>
  
  <pre><code>string colname="ProductID";
  string condition="111";
  DataView dv = new DataView();
  dv.Table = ds.Tables[0] ;
  dv.RowFilter ="CAST ("+colname+" AS TEXT) LIKE '"+ condition+"%'"  ;
  </code></pre>