I have coded a project in vb.net.
It contains code that retrieves around 15 lakh records from the database and displays them in a grid.
I use data adapter and fill the dataset with it.
Then I specify the dataset as the datagrid's datasource.
Now the problem is that on running the project, the system takes a lot of time and finally the message "the page cannot be displayed" appears.
There is no problem with the queries, I have tested all of them in the query analyzer.
Can anyone help me out? Why is it so?
Is retieving of such a large number of records in the data adapter inappropriate?
If yes, then plz specify a solution.
In case I try to retieve only the top 10 or top 15 records, the project runs fine.
My pc has 512 MB of RAM.