如何只将少量列提取到gridview中 [英] How to fetch only few columns into gridview

问题描述

如果我有一个包含1000条记录的网格，当我尝试将数据绑定到网格中时，所有记录都会进入网格。它导致我的应用程序变慢。我想一次获取少量记录，即如果页面大小最初为20，则应该加载20条记录，在发送页面之后它应该来自21条记录并且应该只获取20条记录来自数据库。



谢谢你

解决方案

你应该在gridview中使用SQL custome paggin

看看.. :)



使用SQL Server和.Net C＃进行通用自定义分页和排序 [ ^ ]



SQL Server 2012中的自定义分页 [ ^ ]



如何使用SQL Server存储过程在ASP.Net GridView中实现自定义分页 [ ^ ]



使用gridview中的存储过程在asp.net中自定义分页 [ ^ ]



尝试在google中使用sql探索有关使用gridview进行pagging的更多信息.. :) / BLOCKQUOTE>

Hi, If i have a grid with 1000 records, when i am trying to bind the data into grid all the records are coming into the gird. It is causing my application slow.I want to fetch the records few at a time, i.e if the page size is 20 initially it should load 20 records, after going to send page it should come from the 21 record and should fetch only 20 records from Database.

Thank You

解决方案

You should use SQL custome paggin in gridview
Take a look.. :)

Generic Custom Paging and Sorting Using SQL Server and .Net C#[^]

Custom Paging in SQL Server 2012[^]

How to implement Custom Paging in ASP.Net GridView using SQL Server Stored Procedure[^]

Custom paging in asp.net using stored procedure in gridview[^]

try to explore more regarding pagging in gridview using sql in google.. :)

这篇关于如何只将少量列提取到gridview中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！