Problem - Inserting new record in a GridView at certain position, after a certain row

Thanks, but when I add the new record it gets the row number automatically increased by one comparing to the last inserted (the column has type identity), not a number that follows the record where it should be inserted. So when I sort the table it will remain at the same position. I want all the records that should follow the inserted one, to get a new ordering number increased by one. In fact the whole table to be ordered again.