DATAGRID分页，增加首页、最后一页（源码）

Posted on 2007-01-09 13:07 semye 阅读(1032) 评论(1) 收藏举报

private void PageCut_Click(Object sender,System.EventArgs e)
2

{
3

String commangArg = ((LinkButton)sender).CommandArgument ;
5

switch(commangArg)
6

{
7

//第一页
8

case "First":
9

{
10

DG_ZONE_CONTENT.CurrentPageIndex = 0;
11

break;
12

}
13

//上一页
14

case "Prev":
15

{
16

DG_ZONE_CONTENT.CurrentPageIndex = (int)Math.Max(0,DG_ZONE_CONTENT.CurrentPageIndex - 1);
17

break;
18

}
19

//下一页
20

case "Next":
21

{
22

DG_ZONE_CONTENT.CurrentPageIndex = (int)Math.Min(DG_ZONE_CONTENT.PageCount-1,DG_ZONE_CONTENT.CurrentPageIndex +1);
23

break;
24

}
25

//最后一页
26

case "Last":
27

{
28

DG_ZONE_CONTENT.CurrentPageIndex = DG_ZONE_CONTENT.PageCount -1;
29

break;
30

}
31

default:{break;}
32

}
33

this.Binder(this.TXT_SEARCH_NAME.Text.Trim().ToUpper(),this.TXT_SEARCH_CD.Text.Trim().ToUpper());
35

//控制页面导向按钮的可见性
36

　　　　　　IsFirstLastPage();
37

}
38

/// <summary>
39

/// 控制页面导向按钮的可见性
40

/// </summary>
41

private void IsFirstLastPage()
42

{
43

if(DG_ZONE_CONTENT.PageCount > 0)
44

{
45

PageFirst.Visible = true;
46

PageLast.Visible = true;
47

PageNext.Visible = true;
48

PagePrev.Visible = true;
49

if(DG_ZONE_CONTENT.PageCount != 1)
51

{
52

if(DG_ZONE_CONTENT.CurrentPageIndex == 0)
53

{
54

PagePrev.Enabled = false;
55

}
56

else
57

{
58

PagePrev.Enabled = true;
59

}
60

if(DG_ZONE_CONTENT.CurrentPageIndex == DG_ZONE_CONTENT.PageCount -1)
61

{
62

PageNext.Enabled = false;
63

}
64

else
65

{
66

PageNext.Enabled = true;
67

}
68

}
69

else
70

{
71

PagePrev.Enabled = false;
72

PageNext.Enabled = false;
73

}
74

}
75

else
76

{
77

PageFirst.Visible = false;
78

PageLast.Visible = false;
79

PageNext.Visible = false;
80

PagePrev.Visible = false;
81

}
83

}
84

private void Binder(string zone,string city)
85

{
86

bl = new ZoneConten();
87

DataTable dt = new DataTable();
88

if(zone==""&&city=="")
89

{
90

dt= bl.ZoneRev("ZONE_INFO");
91

}
92

else
93

{
94

dt = bl.zoneSea(zone,city);
95

}
96

this.DG_ZONE_CONTENT.DataSource = dt;
97

this.DG_ZONE_CONTENT.DataBind();
98

if(dt!=null)
99

{
100

if(dt.Rows.Count>0)
101

{
102

int nTotalCode = dt.Rows.Count;
103

//int nTotalPage = nTotalCode/10;
104

// if(nTotalCode%10>0)
105

// {nTotalPage=nTotalPage+1;}
106

// int a = 0;
107

//this.LBL_TOTAL.Text=nTotalPage.ToString();
108

this.LBL_TOTAL.Text = nTotalCode.ToString();
109

int nNow = this.DG_ZONE_CONTENT.CurrentPageIndex+1;
110

this.LBL_NOW.Text=nNow.ToString();
111

}
112

}
113

else
114

{
115

this.LBL_TOTAL.Text = "0";
116

this.LBL_NOW.Text="1";
117

}
118

this.IsFirstLastPage();
119

}
120

<asp:datagrid id="DG_ZONE_CONTENT" runat="server" Width="792px" GridLines="Horizontal" AutoGenerateColumns="False"

AllowPaging="True" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" BackColor="White"

CellPadding="4">

<asp:TemplateColumn HeaderText="行区代码">

<%#DataBinder.Eval(Container,"DataItem.ZONE_CD") %>

<asp:TextBox id=TXT_ZONE_CD_VIS runat="server" Width="58px" Height="20px" Visible="false" text='<%#DataBinder.Eval(Container,"DataItem.ZONE_CD")%>'>

</asp:TextBox>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="行区名">

<%# DataBinder.Eval(Container,"DataItem.AERA_NAME")%>

<asp:TextBox id=TXT_ZONE_NAME_VIS runat="server" Width="164px" Visible="False" Text='<%# DataBinder.Eval(Container,"DataItem.AERA_NAME")%>'>

</asp:TextBox>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="城市代码">

<%# DataBinder.Eval(Container,"DataItem.CITY")%>

<asp:TextBox id=TXT_ZONE_CITY_VIS runat="server" Width="135px" Visible="False" Text='<%# DataBinder.Eval(Container,"DataItem.CITY")%>'>

</asp:TextBox>

</ItemTemplate>

</asp:TemplateColumn>

<asp:ButtonColumn Text="修改" CommandName="Select">

</asp:ButtonColumn>

<asp:ButtonColumn Text="删除" CommandName="Delete">

</asp:ButtonColumn>

</Columns>

</asp:datagrid>

</td>

</tr>

<tr>

<td>

<asp:linkbutton id="PageFirst" Runat="server" CssClass="Normal" Text="首页" CommandArgument="First"></asp:linkbutton> 

<asp:linkbutton id="PagePrev" Runat="server" CssClass="Normal" Text="上一页" CommandArgument="Prev"></asp:linkbutton> 

<asp:linkbutton id="PageNext" runat="server" CssClass="Normal" Text="下一页" CommandArgument="Next"></asp:linkbutton> 

<asp:linkbutton id="PageLast" Runat="server" CssClass="Normal" Text="最后一页" CommandArgument="Last"></asp:linkbutton> 

共<asp:label id="LBL_TOTAL" runat="server">Label</asp:label> 条记录，当前第

<asp:label id="LBL_NOW" runat="server">Label</asp:label> 页

</td>

</tr>

刷新页面返回顶部

semye-静心

公告

DATAGRID分页，增加首页、最后一页（源码）