title: Filtering sql data with multiple filter vb.net (winform)
body: <p>I want to filtering data from SQL to my datagrid.</p>
  
  <p>I have :</p>
  
  <p>1 table (tableX)</p>
  
  <p>3 Columns</p>
  
  <pre><code> Col1    Col2      Col3
  1/x/10    BJB    1/20/20
  1/y/10    BJB    1/20/30
  1/x/10    BJB    1/20/30
  1/y/10    BJB    1/20/20
  </code></pre>
  
  <p>2 datagrid (dg1, dg2)</p>
  
  <p>i want insert :</p>
  
  <p>dg1 with col1 "1/x/10" and col3 "10/20/20"</p>
  
  <p>dg2 with col1 "1/y/10 and col3 "10/20/20</p>
  
  <p>i can filter with only one Col3</p>
  
  <pre><code>"SELECT Col1, Col2, Col3  FROM Tablex WHERE Col3='10/20/20'"
  </code></pre>
  
  <p>how to filter col1 witch contain "x" or "y" and col3?</p>
  
  <p>==========================================================================</p>
  
  <p>O YEAH.. thanks for the answer.</p>
  
  <p>this for dg1</p>
  
  <pre><code>("SELECT Col1, Col2, Col3  FROM TableX WHERE Col1 like ('%/X/%') AND Col3='10/20/20'")
  </code></pre>
  
  <p>and this for dg2, the different is just X and Y..lol</p>
  
  <pre><code>("SELECT Col1, Col2, Col3  FROM TableX WHERE Col1 like ('%/Y/%') AND Col3='10/20/20'")
  </code></pre>