title: Filter records based on Time using Dataview Rowfilter
body: <p>Is it possible to get records between a Timespan from a DataTable using the RowFilter property of the Defaultview that belongs to the table.</p>
  
  <p><strong>Purpose:</strong>
  I would like to check if <code>Current Time(DateTime.Now.ToString())</code> falls withing the Time defined in the Database table schema. Schema of the table is defined below</p>
  
  <pre><code>                          `Name | From | To | JoinedOn |`
  </code></pre>
  
  <p>where From To are datetime columns on the database table. I would like to compare only time values from the datetime columns rather than the dates also. I Tried below but doesn't yield the result.
  <code>dt_Temp.DefaultView.RowFilter = "From &lt; '"+ DateTime.Now.ToString()+"' AND To &gt;'"+ DateTime.Now.ToString()+"'";</code> anyone have any idea?</p>
  
  <p><strong>Specs:</strong></p>
  
  <p>.Net Framework 2.0</p>
  
  <p>ViSual studio 2005</p>
  
  <p>Sql server express 2005</p>