How to retrieve large number of rows?

[santosh2natal]

If there are a million of rows rquired to be retrieved i.e. if it is the requirement; then what we do usually is, we scroll down the datawindow till the elevetor of the scroll bar reaches to the bottom. But it starts going up again as the rows are being retrieved. Beacuse of this we have to wait or go on scrolling the datawindow till all the rows are retrieved. Instead doing this
How can we retrieve all these rows simultanesously while viewing the rows retireved in the datawindow. (Not using "retireve as needed")?

 

[asher007]

I don't think you can "retrieve all these rows simultanesously". Large number of row take time to retrieve. You can make your datawindow invisible until all rows retrieved. Then to show it and to scroll to the last row by datawindow_name.ScrollToRow(datawindow_name.RowCount()).

Arnold