asp.net和sqlserver 2005的分页设计建议 [英] Paging design recommendation for asp.net and sqlserver 2005

问题描述

我对编程还比较陌生.我的工作基本上围绕数据和分析.我想创建一个简单的asp.net页面，该页面显示来自数据库的大量数据.可能有数百万行数据用于不同类型的分析/搜索/过滤等.

I am relatively new to programming. My work basically revolves around data and analysis. I want to create a simple asp.net page which shows huge chunk of data from the database. There could be a millions of rows of data which is used for different kinds of analysis/searchin/filtering etc..

我应该在前端还是后端(在这种情况下为SQL Server 2005)编写分页逻辑?

Should I write paging logic at the front end or at the back-end (in this case SQL Server 2005)?

围绕此的最佳实践是什么?非常感谢您对此方向的建议/与资源的链接.

What would be the best practice around this? Your suggestions/links to resources in this direction is greatly appreciated.

推荐答案

请使用以下示例 在ASP.NET中对大型结果集进行分页 ListView和DataPager

Paging of Large Resultsets in ASP.NET ListView and DataPager

在ASP.NET中使用ListView&的自定义分页DataPager

使用SQL Server 2005在ASP.NET中实现自定义分页

这篇关于asp.net和sqlserver 2005的分页设计建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！