HI all,
we have a column filter added to DataGridView, column that would need to be filtered is BirthDate, we are using HR-hr regional settings.
When entering the filter criteria in colWhere we are experiencing “Object cannot be cast from DBNull to other types”
This is probably issue of converting date string to date datatype.
Can you please take look into the issue.
Regards,
D
Hi Dino,
can you please wrap up a small test case ?
You can either post it here or send it to frankATiceteagroup.com
Thanks in advance.
Best regards
Frank
Hi Frank,
please find attached sample.
Please note that this error is raised when there is NULL value in the column that you are trying to filter, I was expecting that his rows will be ignored / filtered by default.
Regards,
Dino
Hi Dino,
thanks for providing further information and a test case.
I have enhanced the column filter to handle null DateTime values.
Please update from https://github.com/iceteagroup/wisej-extensions
It will also be included in the next Wisej release.
Best regards
Frank
Please login first to submit.