471,330 Members | 1,220 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,330 software developers and data experts.

GridView Sorting w/ NULLs Last

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(DateColumn,'Z'), but the program errors out with, Cannot find
column ISNULL(DateColumn.

Is there an easy way to sort the column and place the NULLs last?

Thanks in advance for your help,
Jun 27 '08 #1
0 918

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by tfsmag | last post: by
1 post views Thread by Terry Olsen | last post: by
5 posts views Thread by Cindy Lee | last post: by
4 posts views Thread by =?Utf-8?B?R2VyaGFyZA==?= | last post: by
1 post views Thread by Evan M. | last post: by
3 posts views Thread by Nathan Sokalski | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.