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.
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.
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.
Please login first to submit.