Busy cursor whilst custom sorting DataGridView C#

Question

Hello I am trying to show a busy cursor icon whilst programmatically sorting my datagridview for a column. As I have a lot of data it can take 10 seconds to sort and I would like to show a busy cursor for this duration. I can show the busy cursor icon when the user clicks on the column header cell (event). However I cant find a suitable event on which to return to the normal cursor. Any ideas? Thanks

solara · Answer

Here's the final code which also manages the glyph's properly: private void dgdTrades_ColumnHeaderMouseClick( object sender DataGridViewCellMouseEventArgs e) { statusLabel.Text = Sorting... ; this .Cursor = Cursors .WaitCursor; for ( int i = 0; i { if (e.ColumnIndex==i) { if (dgdTrades.Columns[e.ColumnIndex].HeaderCell.SortGlyphDirection != SortOrder .Ascending) { dgdTrades.Sort(dgdTrades.Columns[e.ColumnIndex] ListSortDirection .Ascending); dgdTrades.Columns[e.ColumnIndex].HeaderCell.SortGlyphDirection = SortOrder .Ascending; } else { dgdTrades.Sort(dgdTrades.Columns[e.ColumnIndex] ListSortDirection .Descending); dgdTrades.Columns[e.ColumnIndex].HeaderCell.SortGlyphDirection = SortOrder .Descending; } } else { dgdTrades.Columns[i].HeaderCell.SortGlyphDirection = SortOrder .None; } } statusLabel.Text =  ; this .Cursor = Cursors .Default; }

Manikavelu Velayutham · Answer

Great. Surely this post will help others also.

solara · Answer

Eventually figured it out. I had to change the column properties for the DGV to be Programmatic rather than Automatic. It means you have to manually change the glyphs and invoke the sort manually from the column header click event. I can still also use my existing SortCompare method. eg to sort by column 2..... private void dgdTrades_ColumnHeaderMouseClick( object sender DataGridViewCellMouseEventArgs e) { this .Cursor = Cursors .WaitCursor; dgdTrades.Sort(dgdTrades.Columns[2] ListSortDirection .Ascending); dgdTrades.Columns[2].HeaderCell.SortGlyphDirection = SortOrder .Ascending; this .Cursor = Cursors .Default; }

solara · Answer

Yes

Manikavelu Velayutham · Answer

Have you done the custom sorting using SortCompare event handler ?

solara · Answer

Sorry its not quite so simple. As I get an event for each row comparison to do the custom sorting. Like I said I cant find a suitable event on which to switch back to the default cursor after the sorting has completed.

Manikavelu Velayutham · Answer

Then its so simple. following code will help you to implement. Cursor .Current = Cursors .WaitCursor; try { Thread .Sleep(5000); } finally { Cursor .Current = Cursors .Default; }

solara · Answer

Windows Forms app

Manikavelu Velayutham · Answer

Is it a Web or Windows application ?

solara · Answer

Sorry I should have mentioned I am doing this in Visual Studio 2008 C#

Manikavelu Velayutham · Answer

If you are using AJAX in your application it will be easier to implement this one. Sample ASPX code