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.
- string Today = DateTime.Now.ToString();
- string FilterCmd = string.Format("ColumnName = #{0}#", Today);