Last Updated:
08 May 2025 11:45
by ADMIN
GridView: Distinct values are not displayed when setting the FilterMemberPath to the Date property of a DateTime DataTable column when it contains DBNull.Value
Distinct values are not displayed when setting the FilterMemberPath to the Date property of a DateTime DataTable column when it contains DBNull.Value.
Generally, this is present because while the distinct values are generated, we check for the Date property in each row, however, when it reaches a row that has a DBNull.Value value, an exception is thrown because the Date property cannot be found in null.