What maybe easier is what I said before. The problem with this solution maybe that copying may take too long depending on how many rows there are. Imagine you have 10000 rows and you want to insert a row at index 2, that means you need to copy nearly 30000 bits of data around instead of nearly 10000 if you have a single column that is your index column, granted that is still too much messing around. You can still make that key column invisible and sort on it though.
The other thing you could do is implement custom databinding on a non-dataset object. That way you can make changes at an instant by overrideing the indexer of the IList or IBinding list property of whatever object you have.
Imported from legacy forums. Posted by Chris (had 497 views)