網(wǎng)絡編程教程模板無憂>建站教程>網(wǎng)絡編程>.Net教程>

解析簡單實用的DataGrid自定義分頁源程序_.Net教程

教程Tag：暫無Tag,歡迎添加,賺取U幣!

推薦：詳解datalist的用法
設計模版：頁眉 HeaderTemplate /HeaderTemplate 頁腳 FooterTemplate /FooterTemplate 數(shù)據(jù)記錄 ItemTemplate /ItemTemplate AlternatingItemTemplate交替顯示項 /AlternatingItemTemplate SelectedItemTemplate選中時的顯示方式 /SelectedItemTemplate Ed

首先新建一個名為article.aspx的文件,將以下內(nèi)容拷貝到article.aspx.cs中:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class article : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        int cpage = Convert.ToInt32(Request.QueryString["page"]);
        if(cpage==0)
        {
            this.hlFrontPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"];
            this.hlNextPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"] + "?page=" + Convert.ToString(cpage + 2);
        }
        else
        {
            this.hlFrontPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"] + "?page=" + Convert.ToString(cpage - 1);
            this.hlNextPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"] + "?page=" + Convert.ToString(cpage + 1);
        }
        this.hlFirstPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"];
             dataBin();
        //***************************************************
        //PageCount的值必須在數(shù)據(jù)綁定之后才能得到,否則只能是0
        //***************************************************
        int lastPage =this.DataGrid1.PageCount;//lastPage是記錄總頁數(shù)
        this.hlLastPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"] + "?page="+Convert.ToInt32(lastPage);
        if (cpage ==Convert.ToInt32(this.DataGrid1.PageCount))
        {
            this.hlNextPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"] + "?page=" + Convert.ToString(lastPage);
            this.hlFrontPage.NavigateUrl = Request.ServerVariables["SCRIPT_NAME"] + "?page=" + Convert.ToString(cpage - 1);
        }
        this.lbShowMess.Text= "當前第"+Convert.ToInt32(this.DataGrid1.CurrentPageIndex+1)+"頁";
    }
    public void dataBin()
    {
        DB mydb = new DB();
        SqlConnection conn = mydb.createConn();
        conn.Open();
        SqlDataAdapter sdr = new SqlDataAdapter();
        DataSet ds = new DataSet();

        sdr.SelectCommand = new SqlCommand("select * from [User]", conn);
        sdr.Fill(ds, "users");

        int page=Convert.ToInt32(Request.QueryString["page"]);
        if (page == 0)
        {
            page = 1;
        }
        this.DataGrid1.CurrentPageIndex =Convert.ToInt32(page-1);
        this.DataGrid1.DataSource = ds.Tables["users"];
        this.DataGrid1.DataBind();
        conn.Close();
    }
    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {

    }
}

再將以下內(nèi)容拷貝到article.aspx中

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="article.aspx.cs" Inherits="article" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>無標題頁</title>
    <mce:style type="text/css"></mce:style><style type="text/css" mce_bogus="1">    @import url(’css.css’);
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div style="text-align: center" mce_style="text-align: center">
        <asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" AllowPaging="True" OnPageIndexChanged="DataGrid1_PageIndexChanged" Width="500px" ShowHeader="False" BackColor="White" BorderColor="#CC9966" BorderStyle="None" CellPadding="4" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" GridLines="None">
            <Columns>
                <asp:TemplateColumn>
                <ItemTemplate>
                <%# DataBinder.Eval(Container.DataItem,"id") %>
                </ItemTemplate>
                    <HeaderStyle Width="10px" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" HorizontalAlign="Left" />
                </asp:TemplateColumn>
                <asp:TemplateColumn>
                  <ItemTemplate>
                <%# DataBinder.Eval(Container.DataItem,"Uid") %>
                </ItemTemplate>
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" HorizontalAlign="Left" />
                    <HeaderStyle Width="450px" />
                </asp:TemplateColumn>
                <asp:TemplateColumn>
                  <ItemTemplate>
                <%# DataBinder.Eval(Container.DataItem,"title") %>
                </ItemTemplate>
                    <HeaderStyle Width="30px" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" HorizontalAlign="Center" />
                </asp:TemplateColumn>
                <asp:TemplateColumn>
                  <ItemTemplate>
                      <input id="Checkbox1" type="checkbox" value="<%# DataBinder.Eval(Container.DataItem,"id") %>" />
                </ItemTemplate>
                    <HeaderStyle Width="10px" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" HorizontalAlign="Center" />
                </asp:TemplateColumn>
            </Columns>
            <PagerStyle Visible="False" BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
            <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
            <ItemStyle BackColor="White" ForeColor="#330099" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
        </asp:DataGrid>  <br />
        <asp:HyperLink ID="hlFirstPage" runat="server">首頁</asp:HyperLink>
            <asp:HyperLink ID="hlFrontPage" runat="server">上一頁</asp:HyperLink>
        <asp:HyperLink ID="hlNextPage" runat="server">下一頁</asp:HyperLink>

        <asp:HyperLink ID="hlLastPage" runat="server">末頁</asp:HyperLink>
        <asp:Label ID="lbShowMess" runat="server" Width="104px"></asp:Label></div>
    </form>
</body>
</html>

分享：解讀訪問本機IIS站點被要求輸入用戶名和密碼
訪問發(fā)布在本機IIS上的站點時，老彈出一個框要求輸入用戶名密碼，而輸入本機的管理員帳戶，卻還是彈出這個框來。這個問題非常煩，網(wǎng)上的意見如下： 1.設置發(fā)布目錄文件夾的訪問權(quán)限，允許everyone訪問。 2.設置IIS安全選項卡中，允許匿名訪問。這里漏過了一

ASP.NET視頻教程

北大青鳥ASP.NET編程視頻教程

ASP.NET一夜速成視頻教程

ASP.NET語音視頻教學

21天學通ASP.NET40小時多媒體語音視頻教學DVD

ASP.NET3.5從入門到精通視頻

.NET教學視頻免費下載

asp.net夜話教學視頻【完】

來源：模板無憂/所屬分類：.Net教程/更新時間：2010-02-26

[收藏][報錯][返回列表]

相關(guān).Net教程：

欧美日韩精品在线,国内精品久久久久久久久,一级毛片恃级毛片直播,清纯唯美亚洲综合欧美色

解析簡單實用的DataGrid自定義分頁源程序_.Net教程

ASP.NET視頻教程

.Net教程Rss訂閱編程教程搜索

.Net教程推薦

猜你也喜歡看這些