且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

网格视图中有10万条记录

更新时间:2023-01-28 19:48:01

:)您正在测试吗?

好吧,因此永远不会根据加载时间和所有(基本上是性能问题)建议在单个页面上显示所有内容.

现在,假设您要在给定的情况下进行操作,则可以基于浏览器上的网格显示来进行操作.获取屏幕上可见的前100条记录,然后当有人向下滚动时获取更多记录.粗略地讲,您可以通过滚动来计算行号,并尝试使用XMLHttprequest来获取该行号.
:) Are you taking some test?

Well, as such showing all on a single page would NEVER be suggested based on the time it would take to load and all (basically the performance issues.)

Now, suppose you want to in a given scenario, then you can do it based on the grid display on browser. Fetch some first 100 records that is visible on screen and then when someone scrolls down then fetch more. Roughly, you can calculate the row number from scrolling and try to fetch records around that using XMLHttprequest.


在gridview中一次加载100000条记录是一个可怕的人.使用分页技术.

SQL Server 2005分页结果 [
It''s horrible man to load 100000 records at a time in gridview. Use Paging technique.

SQL Server 2005 Paging Results[^]


我们不为您做作业.
自己尝试,如果遇到麻烦,请向我们询问.
但是不要期望我们将它交给您!
We do not do your homework for you.
Try it yourself, and if you get stuck, ask us then.
But don''t expect us to hand it to you on a plate!