Maintaining a sorted view on a datagrid

[Docarctiss]

Hello every one,
this is what i would like to achieve .....

Once i click on a column header in a datagrid it sorts the rows, i select a row to edit but once i accept the edit i don't want it to "resort" or "refresh". it must stay the same as the time i sorted the column header.

I am using a datagrid.

[arnaudk]

Is this an Excel question? Is this even a question?

[Docarctiss]

Sorry if i was not clear on the statement\ question,

it is Visual Studios, windows form, i populate the form with a datagrid, and set the property to sortable. but i dont want the datagrid to resort once i updated it in the DB. so i would like to Clone the sorted view that i had to start off with.

i hope this helps.