Sorting Sheridan Datawidgets 3.0 DataGrid

11-10-2004, 08:10 AM
I have coded a sort routine for my grid which works the way I need it to except for one small problem. I read the cell contents into a 2 dimensional array, sort the array and then move it back into the grid. When I read in the cell contents I go down through the rows using the MoveNext command. When the rows of the grid are displayed down past the bottom of the screen, it will scroll down through every one of the rows. The users are finding this very annoying, especially if they have a couple hundred records in the grid. Is there a way to extract all of the cell contents without affecting the users view of the grid?

For intX = 0 To intRows - 1
For intY = 0 To intCols - 1
varGrid(intX, intY) = pGrid.Columns(intY).Value

Mike Joncas

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum