Quote:
What is the best method to browser cache 10 lac records from SQL database in ASP.NET?
The best method is to not do it.
Loading the phone directory of your country in a droplist is a bad idea. Even a rate of 1000 records per second makes it 20 minutes to load.
Advice: look at web sites on similar subject, and see how they deal with the problem.