Effective Paging in a Gridview From a Stored Procedure

Jes Sie

Hello everyone,

I found this article "https://www.codeproject.com/Articles/125541/Effective-Paging-with-GridView-Control-in-ASP-NET" which explains how to implement an effective sorting. Unfortunately, the author is using an ObjectDataSource to display the data to the grid view while I am displaying the data from the code behind. Can someone help me to implement his idea from the code behind? Below is the gridview and ObjectDataSource mark-up

<div>
<asp:GridView ID="gvProfile" DataSourceID="profileDataSource" runat="server" AutoGenerateColumns="false"
AllowPaging="true" AllowSorting="true" PageSize="5" HeaderStyle-Font-Names="Verdana"
Font-Size="Small" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Font-Underline="false"
Width="55%" HeaderStyle-BackColor="BurlyWood" HeaderStyle-ForeColor="Navy">
<AlternatingRowStyle BackColor="Aquamarine" />
<Columns>
<asp:BoundField DataField="ProfileId" HeaderText="Profile Id" SortExpression="ProfileId"
ItemStyle-Width="6%" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" ItemStyle-Width="13%" />
<asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address"
ItemStyle-Width="18%" />
<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" ItemStyle-Width="8%" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" ItemStyle-Width="9%" />
<asp:BoundField DataField="IsActive" HeaderText="Status" SortExpression="IsActive" ItemStyle-Width="4%" />
Columns>
asp:GridView>
div>
center>
<asp:ObjectDataSource ID="profileDataSource" runat="server" SelectMethod="GetProfileData" EnablePaging="true" MaximumRowsParameterName="pageSize"
StartRowIndexParameterName="startRowIndex" TypeName="VTS.Web.UI.ProfileDataSource" SelectCountMethod="TotalRowCount"
SortParameterName="sortExpression">
<SelectParameters>
<asp:Parameter Name="startRowIndex" Type="Int32" />
<asp:Parameter Name="pageSize" Type="Int32"/>
<asp:Parameter Name="sortExpression" Type="String" />
SelectParameters>
asp:ObjectDataSource>

Thank you in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jes Sie5y ago
Thanks, Sachin for your response. this is not just a simple displaying of data from SQL Server. I have also several methods from the code behind. Currently, I only have the normal paging of the gridview. By the way, this table has already had > 50,000 rows of data. And the client wants me to display them all. By using the normal paging, it took the SQL Server 30 seconds to display the data. How much more if it will reach 100K or 500K?

I also found this article " https://www.c-sharpcorner.com/UploadFile/99bb20/custom-paging-with-gridview-control-in-Asp-Net-4-5/" but the stored procedure does not display any result.
0
Sachin Singh5y ago
Yes, you can achieve this way, but why do you want to work hard when the same thing can be achieved with datatable easily, just convert your GridView to datatable and that's it.

Just put these script in your Aspx page
"https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js">
"text/javascript" src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js">
"text/css" rel="stylesheet" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" />

"text/javascript">
$(document).ready(function () {
$('#<%= gvProfile.ClientID %>').DataTable();
});
0