page.aspx.cs

互联网程序设计的课程

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    string myConnetionString = "server=XS;uid=sa;pwd=123456;database=Diamond;";
    SqlConnection myConnection = new SqlConnection();
    protected void Page_Load(object sender, EventArgs e)
    {
        GridViewBind();
        GridViewBindT();
    }
    private void GridViewBind()
    {
        myConnection.ConnectionString = myConnetionString;
        string cmdString = "select 用户名, 城市, 地址,联系电话 from Customer";
        SqlDataAdapter myAdapter = new SqlDataAdapter(cmdString, myConnection);
        myConnection.Open();
        DataSet mySet = new DataSet();
        myAdapter.Fill(mySet);
        myGridView1.DataSource = mySet;
        myGridView1.DataBind();
        myConnection.Close();
    }
    private void GridViewBindT()
    {
        myConnection.ConnectionString = myConnetionString;
        string cmdString = "select 用户名, 城市, 地址,联系电话 from Customer";
        SqlDataAdapter myAdapter = new SqlDataAdapter(cmdString, myConnection);
        myConnection.Open();
        DataSet mySet = new DataSet();
        myAdapter.Fill(mySet);
        myGridView2.DataSource = mySet;
        myGridView2.DataBind();
        myConnection.Close();
    }

    protected void PageCut_Click(object sender, EventArgs e)
    {
        string commandArg = ((LinkButton)sender).CommandArgument;
        switch (commandArg)
        {
            case "First":
                myGridView1.PageIndex = 0;
                break;
            case "Prev":
                myGridView1.PageIndex = (int)Math.Max(0, myGridView1.PageIndex - 1);
                break;
            case "Next":
                myGridView1.PageIndex = (int)Math.Min(myGridView1.PageCount - 1, myGridView1.PageIndex + 1);
                break;
            case "Last":
                myGridView1.PageIndex = myGridView1.PageCount - 1;
                break;
        }
        GridViewBind();
    }
    private void IsFirstLastPage()
    {
        if (myGridView1.PageCount > 0)
        {
            if (myGridView1.PageCount != 1)
            {
                if (myGridView1.PageIndex == 0)
                {
                    
                }
            }
        }
    }

    protected void myGridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        myGridView2.PageIndex = e.NewPageIndex;
    }
}