Fahad Abdul Azeez

Fahad Abdul Azeez

  • NA
  • 26
  • 7.2k

DataView RowFilter not working

Sep 18 2017 5:44 PM
I am working on a simple database c# program. Using MS Access as end database. I have a form with datagridview, using Dataview as Datasource.
 
When I try to use DataView.Row filter, All operators (<, >, <=, >=) are working except = (equal) not working. My column datatype is DateTime. That part of the code is shown below.
 
Advance thanks, Please help.
  1. string Today = DateTime.Now.ToString();  
  2. string FilterCmd = string.Format("ColumnName = #{0}#", Today);

Answers (2)