Null Sort Issues on Datagridview

Question

0.00/5 (No votes)

See more:

Hi All,

I have a datagridview which sorts Data in ascending order on a datetime column,
Is there a way to display null date at the end of the grid(when Sorted Ascending).

Please help!!!

As the requirement is urgent.

Regards,
Sibu Varghese.

Posted 28-Jan-12 22:37pm

sibu@varghese

Updated 28-Jan-12 22:48pm

Amir Mahfoozi

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amir Mahfoozi · Answer 1 · 2012-01-28T22:47:00

try this one :

VB

Dim sortedList = custList.
    OrderBy(Function(c) Not c.LastOrderDate.HasValue).
    ThenBy(Function(c) c.LastOrderDate)
DataGridView1.DataSource = sortedList.ToList()

Extracted from here :
http://msmvps.com/blogs/deborahk/archive/2010/10/30/sorting-lists-with-null-values.aspx[^]

Also have a look at these pages :
http://www.access-programmers.co.uk/forums/showthread.php?t=173051[^]

However this code is in C# but it worth conversion :
http://stackoverflow.com/questions/4921054/sorting-datatable-string-column-but-with-null-empty-at-the-bottom[^]

Hope it helps.

Null Sort Issues on Datagridview

1 solution

Solution 1

Add your solution here

Preview 0

Null Sort Issues on Datagridview

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us