winson lee

winson lee

  • NA
  • 6
  • 0

DataGridView - Freeze Column and Row

Aug 19 2008 7:00 PM
Hi,

I have a column that shows the rank from 1-500 and another column that shows the sales for month of Jan. How can I go about freezing the rank column so that when the user click on the Jan header , the data is sorted accordingly but the rank number remain the same ? And how can i go about doing it when I click on the Jan header, the Total row stays at the same place as well? Usually when the jan header is clicked, the Total will be part of the sort as well.

eg

Rank             Jan Sales
1                   $400
2                   $500
3                   $300
Total             $1200

Once a Jan Sales is clicked, it will be

Rank             Jan Sales
1                   $500
2                   $400
3                   $300
Total             $1200

Answers (1)