I have a grid that gets close to real time updates when data changes. when new rows are added to the datasource they are always added to the bottom of the grid instead of the normal position, the grid being sorted on some of the columns. The only way to get the new rows into the correct position is to do a DataBind for the grid which is not very nice. Is there a better way to ensure new rows are displayed in the correct position?
My code is more or less like this: build a datarow rw and then
dT.Rows.Add(rw)
Mygrid.Refresh
Might help to use a BindingSource object, also.