分页显示数据

参考 http://www.bc-cn.net/Article/net/aspx/jszl/200601/3302.html
http://www.51it.org/kaifa/dotnet/Netwenzhai/datagrid/200508/29774.html
html:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>无标题页</title>
</head>
<body>

</body>
</html>

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 tab : System.Web.UI.Page
{
    SqlConnection cn;
    string strsql;
    protected void Page_Load(object sender, EventArgs e)
    {
        // 在此处放置用户代码以初始化页面

        string strconn = ConfigurationSettings.AppSettings["dsn"];
        cn = new SqlConnection(strconn);
       // myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["pubsConnectionString"]);

        if (!IsPostBack)

           BindGrid();

    }

    public void BindGrid()
    {
        //   string strSql = "SELECT * FROM authors";
        // SqlDataAdapter myCommand = new SqlDataAdapter(strSql, myConnection);
        // DataSet ds = new DataSet();
        // myCommand.Fill(ds,"authors");
        ///   MyDataGrid.DataSource = ds.Tables[0].DefaultView;
        ///   MyDataGrid.DataBind();
        //   ShowStatsPage();

        strsql = "select * from student";
        SqlDataAdapter da = new SqlDataAdapter(strsql, cn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        MyDataGrid.DataSource = ds;
        MyDataGrid.DataBind();
        ShowStatsPage();
    }

    private void PagerButtonClick(object sender, System.EventArgs e)
    {
        //获得LinkButton的参数值
        String arg = ((LinkButton)sender).CommandArgument;

    void ShowStatsPage()
    {
        //显示页面信息
        lblCurrentIndex.Text = " 当前为第" +((int)MyDataGrid.CurrentPageIndex + 1) +"页";
        lblPageCount.Text = " 共" + MyDataGrid.PageCount + "页";
      // lblCurrentIndex.Text = " <font color="blue"> 当前为第：" + ((int)MyDataGrid.CurrentPageIndex+1) + "页 </font>";
        //lblPageCount.Text = " [<font color="blue"> 共：" + MyDataGrid.PageCount + "页 </font>]";
    }

    private void MyDataGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
    {
        //处理按下数字的方法
        MyDataGrid.CurrentPageIndex = e.NewPageIndex;
        BindGrid();
    }

    private void btnGo_Click(object sender, System.EventArgs e)
    {
        //页面直接跳转的代码
        if (txtGoPage.Text.Trim() != "")
        {
            int PageI = Int32.Parse(txtGoPage.Text.Trim()) - 1;
            if (PageI >= 0 && PageI < (MyDataGrid.PageCount))
                MyDataGrid.CurrentPageIndex = PageI;
        }
        BindGrid();
    }
    //----------------------翻页代码结束
    protected void btnNext_Click(object sender, EventArgs e)
    {
        //获得LinkButton的参数值
        String arg = ((LinkButton)sender).CommandArgument;

        switch (arg)
        {
            case ("next"):
                if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
                    MyDataGrid.CurrentPageIndex++;
                break;
            case ("prev"):
                if (MyDataGrid.CurrentPageIndex > 0)
                    MyDataGrid.CurrentPageIndex--;
                break;
            case ("fist"):
                MyDataGrid.CurrentPageIndex = 0;
                break;
            case ("last"):
                MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
                break;
            default:
                //本页值
                MyDataGrid.CurrentPageIndex = Convert.ToInt32(arg);
                break;
        }
        BindGrid();
    }
    protected void btnPrev_Click(object sender, EventArgs e)
    {
        //获得LinkButton的参数值
        String arg = ((LinkButton)sender).CommandArgument;

        switch (arg)
        {
            case ("next"):
                if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
                    MyDataGrid.CurrentPageIndex++;
                break;
            case ("prev"):
                if (MyDataGrid.CurrentPageIndex > 0)
                    MyDataGrid.CurrentPageIndex--;
                break;
            case ("fist"):
                MyDataGrid.CurrentPageIndex = 0;
                break;
            case ("last"):
                MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
                break;
            default:
                //本页值
                MyDataGrid.CurrentPageIndex = Convert.ToInt32(arg);
                break;
        }
        BindGrid();
    }
    protected void btnLast_Click(object sender, EventArgs e)
    {
        //获得LinkButton的参数值
        String arg = ((LinkButton)sender).CommandArgument;

        switch (arg)
        {
            case ("next"):
                if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
                    MyDataGrid.CurrentPageIndex++;
                break;
            case ("prev"):
                if (MyDataGrid.CurrentPageIndex > 0)
                    MyDataGrid.CurrentPageIndex--;
                break;
            case ("fist"):
                MyDataGrid.CurrentPageIndex = 0;
                break;
            case ("last"):
                MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
                break;
            default:
                //本页值
                MyDataGrid.CurrentPageIndex = Convert.ToInt32(arg);
                break;
        }
        BindGrid();
    }
    protected void btnFirst_Click(object sender, EventArgs e)
    {
        //获得LinkButton的参数值
        String arg = ((LinkButton)sender).CommandArgument;

        switch (arg)
        {
            case ("next"):
                if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
                    MyDataGrid.CurrentPageIndex++;
                break;
            case ("prev"):
                if (MyDataGrid.CurrentPageIndex > 0)
                    MyDataGrid.CurrentPageIndex--;
                break;
            case ("fist"):
                MyDataGrid.CurrentPageIndex = 0;
                break;
            case ("last"):
                MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
                break;
            default:
                //本页值
                MyDataGrid.CurrentPageIndex = Convert.ToInt32(arg);
                break;
        }
        BindGrid();
    }
    protected void btnGo_Click1(object sender, EventArgs e)
    {
        //页面直接跳转的代码
        if (txtGoPage.Text.Trim() != "")
        {
            int PageI = Int32.Parse(txtGoPage.Text.Trim()) - 1;
            if (PageI >= 0 && PageI < (MyDataGrid.PageCount))
                MyDataGrid.CurrentPageIndex = PageI;
        }
        BindGrid();
    }
}

posted on 2006-12-01 00:39 ipusr 阅读(238) 评论(0) 收藏举报