1
2************************.cs******************************
3protected void Page_Load(object sender, EventArgs e)
4{
5 if (!IsPostBack)
6 {
7 //DataList Paging code start
8 Player objPlayer = new Player();
9 int TotalRecords = objPlayer.getCount((int)AppType.Player);
10 Double total = Convert.ToDouble(TotalRecords) / RecordPerPage;
11 Pages.Value = Convert.ToString(Math.Ceiling(total));
12 BindAppearance();
13 //DataList Pagecode end
14 }
15}
16
17//*********Custom Paging code********************************
18 #region DataListPaging ...
19
20 public void BindAppearance()
21 {
22
23
24 int Page_Number = Convert.ToInt32(PageNumber.Value);
25
26 DataSet dsApp = Player.getAllApp((int)AppType.Player, Page_Number, RecordPerPage);
27 if (dsApp.Tables.Count > 0)
28 {
29 if (dsApp.Tables[0].Rows.Count > 0)
30 {
31 DlstAppearance.DataSource = dsApp.Tables[0].DefaultView;
32 DlstAppearance.DataBind();
33 SetDefaultAppearence(dsApp);
34 }
35 }
36 int PID=0;
37 if(Request.QueryString["PID"]!=null)
38 PID=Convert.ToInt32(Request.QueryString["PID"]);
39
40
41 SetPager();
42 }
43
44 private void SetPager()
45 {
46 List<clsPageNumber> objLPN = new List<clsPageNumber>();
47 PagesDisplay.Text = "";
48 int TotalPages=Convert.ToInt32(Pages.Value);
49 int Page_Number = Convert.ToInt32(PageNumber.Value);
50 for (int i = 1; i <= TotalPages; i++)
51 {
52 object obj = new object();
53
54 clsPageNumber objPN = new clsPageNumber();
55 if (i != Page_Number)
56 objPN.PageNumText = i.ToString();
57 else
58 objPN.PageNumText = "[<B>" + i.ToString() + "</B>]";
59
60 objPN.PageIndex = i;
61 objLPN.Add(objPN);
62
63
64 }
65 rPageNum.DataSource = objLPN;
66 rPageNum.DataBind();
67 FirstPage.Enabled = (Page_Number != 1);
68 PrePage.Enabled = (Page_Number != 1);
69 NextPage.Enabled = (Page_Number != TotalPages);
70 LastPage.Enabled = (Page_Number != TotalPages);
71 }
72
73
74 protected void PageChange_Command(object sender, CommandEventArgs e)
75 {
76 switch (e.CommandName)
77 {
78 case "FirstPage":
79 PageNumber.Value = "1";
80 break;
81 case "PrePage":
82 PageNumber.Value = Convert.ToString((Convert.ToInt32(PageNumber.Value) - 1));
83 break;
84 case "NextPage":
85 PageNumber.Value = Convert.ToString((Convert.ToInt32(PageNumber.Value) + 1));
86 break;
87 case "LastPage":
88 PageNumber.Value = Pages.Value;
89 break;
90 }
91
92 BindAppearance();
93 }
94 public class clsPageNumber
95 {
96 public string PageNumText { get; set; }
97 public int PageIndex { get; set; }
98 }
99 protected void lnkPN_Click(object sender, EventArgs e)
100 {
101 LinkButton lnk = sender as LinkButton;
102 if (lnk != null)
103 {
104 PageNumber.Value = lnk.CommandArgument;
105 BindAppearance();
106 }
107 }
108#endregion
109**************************************************************************
110
111
112
113*******************aspx Page***********************************************
114
115 <div id="Div1" class="Pagination2" style="float:right" runat="server" >
116 <input id="Pages" type="hidden" value="0" runat="server" />
117 <input id="PageNumber" type="hidden" value="1" runat="server" />
118 <asp:LinkButton ID="FirstPage" runat="server" CommandName="FirstPage" OnCommand="PageChange_Command" Text="First"></asp:LinkButton>
119 <asp:LinkButton ID="PrePage" runat="server" CommandName="PrePage" OnCommand="PageChange_Command" Text="Prev"></asp:LinkButton>
120 <asp:Label ID="PagesDisplay" Visible="false" runat="server"></asp:Label>
121 <asp:Repeater ID="rPageNum" runat="server" >
122 <ItemTemplate>
123 <asp:LinkButton ID="lnkPN" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"PageNumText") %>' CommandArgument='<%#DataBinder.Eval(Container.DataItem,"PageIndex") %>' onclick="lnkPN_Click"></asp:LinkButton>
124 </ItemTemplate>
125 </asp:Repeater>
126 <asp:LinkButton ID="NextPage" runat="server" CommandName="NextPage" OnCommand="PageChange_Command" Text="Next"></asp:LinkButton>
127 <asp:LinkButton ID="LastPage" runat="server" CommandName="LastPage" OnCommand="PageChange_Command" Text="Last"></asp:LinkButton>
128 </div>
129
130
131
132*************************Procedure*****************************************
133CREATE PROCEDURE [dbo].[USP_getApp] --3,0,1
134(
135 @ISFOR INT,
136 @PAGEINDEX INT,
137 @PAGESIZE INT
138
139 )
140as
141
142begin
143 CREATE table #TEMPTAB_USERS
144 (
145
146 ID INT IDENTITY(1,1),
147 Appearanceid int,
148 appearanceName varchar(255)
149 )
150Insert into #TEMPTAB_USERS
151Select AppearanceId,AppearanceName from Appearance where IsFor=@Isfor and AppStatus=1
152
153 DECLARE @PAGESTART INT
154 DECLARE @PAGEEND INT
155
156
157
158 SET @PAGESTART=(@PAGEINDEX-1)*@PAGESIZE +1
159 SET @PAGEEND=(@PAGESTART-1)+@PAGESIZE
160
161 select AppearanceId,'../Appearance/'+AppearanceName as AppearanceName from #TEMPTAB_USERS where ID between @PAGESTART and @PAGEEND
162
163END
164
165
166**************************************************************************