I've searched all afternoon to find a somewhat straight-forward (read:
without having to re-write every involved method) way to do this. I
have a GridView that is sortable. I have a date column in that
GridView that can contain a date (if the program has been installed)
or a NULL value (if the program has not been installed). The problem
I'm having is that when I sort the column all of the NULL values
appear at the beginning, when I want them at the end (out of the
way). I've tried changing the SortExpression to
ISNULL(DateColu mn,'Z'), but the program errors out with, Cannot find
column ISNULL(DateColu mn.
Is there an easy way to sort the column and place the NULLs last?
Thanks in advance for your help,
-Sean
without having to re-write every involved method) way to do this. I
have a GridView that is sortable. I have a date column in that
GridView that can contain a date (if the program has been installed)
or a NULL value (if the program has not been installed). The problem
I'm having is that when I sort the column all of the NULL values
appear at the beginning, when I want them at the end (out of the
way). I've tried changing the SortExpression to
ISNULL(DateColu mn,'Z'), but the program errors out with, Cannot find
column ISNULL(DateColu mn.
Is there an easy way to sort the column and place the NULLs last?
Thanks in advance for your help,
-Sean