Hi,

I am currently migrating access programs into vb.net with t-sql database backend.
I am having 400000 rows of data that I have to pass into recordset and display it on the grid.
In the good old access, the data appears almost immediately. Because access does not wait to load all the data before show it in the grid. The data will be gradually built when the user scroll down the grid.

On the other hands, in sql server. I do not know whether this trick is possible. So it is trying to load all 40000 rows before show it on the grid. It takes up to two minutes to open a single grid.
Is there any workaround for this? Thank you

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.