c# - paging in a gridview based on a year field -

c# - paging in a gridview based on a year field -

i trying find way page through gridview table year. in database have "season" field , want of info 2014 shown on 1 page, info 2013 on another, etc. require different numbers of rows based on year.

here how it. wouldn't utilize default paging of gridview handle this. instead, buttons (or linkbuttons) imitate paging command paging. way, able handle alter in year command displayed.

the steps follows:

1) add together gridview page big page size display everything

<asp:gridview id="dgvrequests" runat="server" autogeneratecolumns="false" pagesize="9999"> </asp:gridview>

2) bind per year info in code behind since display everthing per year in page load. store variable track year

public int currentyear { { if(viewstate["currentyear"] != null) homecoming (int)viewstate["currentyear"]; homecoming 2014; //default } set { _viewstate["currentyear"]= value; } } protected void page_load(object sender, eventargs e) { if (!page.ispostback) { dgvrequests.datasource = getyeardata(currentyear); //or variable dgvrequests.databind(); } }

3) create controls command page. used link buttons

<asp:linkbutton id="lbtnprevious" runat="server" onclick="lbtnprevious_click"></asp:linkbutton> <asp:linkbutton id="lbtnlnext" runat="server" onclick="lbtnlnext_click"></asp:linkbutton>

4) on click event, command paging of gridviews via click event

protected void lbtnlnext_click(object sender, eventargs e) { dgvrequests.datasource = getyeardata(++currentyear); //or variable dgvrequests.databind(); } protected void lbtnprevious_click(object sender, eventargs e) { dgvrequests.datasource = getyeardata(--currentyear); //or variable dgvrequests.databind(); }

that should allow "page" in essence using controls instead of paging feature.

** getyeardata function function in grab info from

** may want display current year of info displaying

c# asp.net sql gridview