display 1,00,000 record in asp.net

Jagwinder Walia

hi all i have to display huge data around 1,00,000 records. My client requirement is not to use paging. so i have to display this data in one time. i dont how to display this. cud we use crystal report for this???

N Surendra Prasad

This can be done in different ways, it depends on how you get the source data. 1) If you can get the source data in XML format, then you can design an XSL and present the XML as such. 2) You can frame html with the source data and render the html to the page. 3) you can use Gridview or datagrid without pagination (but this will be slow). The best method is the first one.

N.Surendra Prasad

J4amieC

Im not sure if the number you meant to type was one million or one hundred thousand, but either way if somebody wants you to display that many records on a single page then they are idiots. Firstly this is slow as hell, secondly no user wants nor needs that number of records in one go. ever.

Abhijit Jana

its not recomondate to display this amount of data in web page, it will be very slow responsive page. Better use some filter criteria by which you can at least reduce records.

cheers, Abhijit

Jagwinder Walia

cant we use crystal report for this??

AhsanS

You can use any of the methods mentioned by one of the members in an earlier post. But the problem is it won't be efficient or feasible.

Ahsan Ullah Senior Software Engineer

Christian Graus

The big problem with outsourcing is that the coders just blindly do what the client asks and never have the guts, or the knowledge, to tell the client that what they want is idiotic and technically not viable. What the client wants is idiotic and technically not viable. Pages will time out before they send that much data, and users will never want to navigate it. They could export the data via a file download, and view it in Excel or something, but not in the page.

Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.