Community

I am working with VB6 in regard to this project.

I have two data grids. (DataGrid1 & DataGrid2)

DataGrid1 is populated with a large number of rows of data. (450,000+ rows)

DataGrid2 is populated with a large number of rows of data. (200,000+ rows)

Is there a realistic and fast method to copy the data from DataGrid2 to DataGrid1?

So that DataGrid1 will then contain all 650,000 rows of data?

The data is coming from two different data sources, and for the purposes of this project, they also must be loaded into two different DataGrids initially, but I need to end up with all the data on DataGrid1.

Since the number of rows of data is rather large, simply looping through each row and adding the item would be time intensive and costly, I need to
find a faster bulk copy/merge method for this.

Any suggestions and/or code examples would be appreciated.