Get Sorted Column

[Jose Luis Melo]

Hi,

I want to update a databoundgrid datasource, but keep the sorted column sorted.

How can I get the sorted column, and its sorting method, and insert it again when datasource is updated ?

Thanks,
Luis Melo

[Administrator]

If your datasource is a DataTable, then you can try saving the dataTable1.DefaultView.Sort property. Then after the update, you can reset it.

string save = this.dataTable1.DefaultView.Sort;

//update things...

this.dataTable1.DefaultView.Sort = save;

[Jose Luis Melo]

Sorry,

I think I forgot to tell you that the Sort I wanted to save was the one I selected in the FilterBar''s grid.

If I click on the 3rd column and make the column sorted by that column, then when I update the datasource''s grid, I would like to replace the sort I selected before.

Thanks again,
Luis Melo

[Administrator]

Do you mean the filter instead of the sort? If so, you would save and restore the RowFilter property instead of the Sort property.

string save = this.dataTable1.DefaultView.RowFilter;

//update things...

this.dataTable1.DefaultView.RowFilter = save;