muro
Active member
- Joined
- Apr 30, 2018
- Messages
- 26
- Programming Experience
- 3-5
C#:
myBindingSource.Filter = $" StartTime not like 'now' AND (OrderTime >= #{DateTime.Now:MM/dd/yyyy}# AND OrderTime < #{DateTime.Now.AddDays(1):MM/dd/yyyy}#)";
I had this code and it worked good but then i decided to change OrderTime coloumn type in sql to nvarchar , it used to be datetime2. Unfourtunately this bindingsource filter above wont work anymore so i tried somethign like this but still no succes:
C#:
myBindingSource.Filter = $" StartTime not like 'now' AND (CONVERT(OrderTime,System.DateTime) >= #{DateTime.Now:MM/dd/yyyy}# AND (CONVERT(OrderTime,System.DateTime) < #{DateTime.Now.AddDays(1):MM/dd/yyyy}#)";
Last edited: