c# - Sort Issue on Databound Grid -
my datagridview bound datatable, after binding datagridview datatable, adding new row datatable @ 0 index, row serve grandtotals row, row frozen, working fine except when user click on 1 of column headers sort grid, top grand totals row gets sorted , row appears grand totals row result of sort operation, discovered when grid binded datatable, cannot access sortcompare event of grid, tried make copy of top row when user click on column header can add in sorted event (this event firing up) columnheadermouseclick event not firing up.
any advice on situation, goal keep grand totals row on top.