Loading

sorting datagrid with empty rows

ckjfr99

I have datagrid that I'm filling with rows, if the rows don't fill up the size of the grid, then I'm adding new empty rows from my dataview in my derived datagrid. The problems that comes up is that when im sorting the columns the empty rows are also sorted (not the last one, and i don't know why the last one is not sorted). Qestion: can i somehow sort the filled rows and just letting the empty (DBNULL) just be in the bottom of my grid?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski21y ago
Last row is not sorted, because of it's only "virtually" added. It is a DataGrid functionality. To avoid this row set AllowNew=false in displayed DataView. To avoid unnecessary sorting, sort DataView manually on invisible column, which has proper values (e.g 0 for non-empty rows, 1 for empty). To avoid manually sorting set AllowSorting=false in DataGrid (if it works; not tested)