Keeping selected records at the top regardless of ordering

[RichJ]

Hi all, 

Just wondering if anyone has any thoughts on this:

We have an order system where order records are presented in a radgrid for paging, sorting etc.
Some orders may be flagged as urgent (or overdue etc) and I'd like these to always show on the top of the first page irrespective of how the grid is sorted (i.e. by order number or status etc).
Paging away from the first page is not an issue.

Can anyone offer suggestions on the best way to do this?

Cheers
Rich

[Elliott]

if your application can handle manual data binding then add a column to the data source and bind your grid to that
when a row is selected mark the datasource - and sort to bubble the selected rows to the top
I had to do something analogous when the SQL tables being displayed did not have a unique key(!)