How to keep selected column in view when sorting a Sheridan Grid

[xcmuchip]

I am using a bound Sheridan grid (ssdbgrid). I have the column sorting working, but when I refresh the data, the grid resets itself at the beginning. Is there a way to keep the column selected in view?

I don't want to change which grid I am using. I would rather not change to unbound. However, I am open to any suggestions.

Thanks

 

[xcmuchip]

I just found the leftcol property for the grid. I have tried to use it but it does not set the column. I have tried setting the property before and after the refresh of the grid. Neither has worked. Any ideas?

Thanks

 

[xcmuchip]

Figured it out for anyone interested. I was having probelms trying to change the value of the leftcol property. Even though the line of code to set the leftcol property would execute, it would keep the value of 0. After some playing, I found that I needed to set the redraw property back to true and refresh the grid first. Then it lets me set the leftcol property.

Grid.Redraw = True
Grid.Refresh
Grid.LeftCol = iSomeNumber