test13.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.Sql;
using System.Data.SqlClient;
using DBClass;
using System.Xml;
using System.Text;
using System.Drawing;
using System.IO;
using System.Web.SessionState;   

public partial class backup_test13 : System.Web.UI.Page
{
    DB db = new DB();

    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {String cmdText = "select * from ZhouQinfo";
        db.BindGridView(cmdText, GridView1);
            IsFirstLastPage();

        }

    }
    

    protected void GridView1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
    {

        GridView1.PageIndex = e.NewPageIndex;
        db.BindGridView(cmdText, GridView1);


    }



    protected void PageCut_Click(object sender, EventArgs e)
    {
        String commangArg = ((LinkButton)sender).CommandArgument;

        switch (commangArg)
        {
            case "First":
                {
                    GridView1.PageIndex = 0;
                    break;
                }
            case "Prev":
                {
                    GridView1.PageIndex = (int)Math.Max(0, GridView1.PageIndex - 1);
                    break;
                }
            case "Next":
                {
                    GridView1.PageIndex = (int)Math.Min(GridView1.PageCount - 1, GridView1.PageIndex + 1);
                    break;
                }
            case "Last":
                {
                    GridView1.PageIndex = GridView1.PageCount - 1;
                    break;
                }
            default:
                {
                    break;
                }
        }
       
        IsFirstLastPage();

    }

    private void IsFirstLastPage()
    {
        if (GridView1.PageCount > 0)
        {
            if (GridView1.PageCount != 1)
            {
                if (GridView1.PageIndex == 0)
                {
                    LinkButton2.Enabled = false;
                }
                else
                {
                    LinkButton2.Enabled = true;
                }
                if (GridView1.PageIndex == GridView1.PageCount - 1)
                {
                    LinkButton3.Enabled = false;
                }
                else
                {
                    LinkButton3.Enabled = true;
                }
            }
            else
            {
                LinkButton2.Enabled = false;
                LinkButton3.Enabled = false;
            }
        }
        else
        {
            LinkButton1.Enabled = false;
            LinkButton2.Enabled = false;
            LinkButton3.Enabled = false;
            LinkButton4.Enabled = false;
        }

    }
}