?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.OleDb;
/// <summary>
/// asp.net2.0空間，六線主機空間,cn域名注冊３０元／年　QQ:59716094
/// </summary>

public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
        
    }
    private void bind()
    {
        OleDbConnection con=new OleDbConnection(ConfigurationManager.ConnectionStrings["test"].ConnectionString);
        OleDbDataAdapter sda=new OleDbDataAdapter("select * from flash,",con);
        DataSet ds = new DataSet();
        sda.Fill(ds,"flash");
        GridView1.DataSource = ds.Tables["flash"];
        GridView1.AllowPaging = true;
        GridView1.PageSize = 5;
        GridView1.DataBind();
        if (GridView1.PageIndex == 0)
        {
            Button1.Enabled = false;
            Button2.Enabled = false;
        }
        else
        {
            Button1.Enabled = true;
            Button2.Enabled = true;
        }
        if (GridView1.PageIndex == GridView1.PageCount - 1)
        {
            Button3.Enabled = false;
            Button4.Enabled = false;
        }
        else
        {
            Button3.Enabled = true;
            Button4.Enabled = true;
        }

    }
    private int cmd(string query)
    {
        OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["test"].ConnectionString);
        con.Open();
        OleDbCommand cmd = new OleDbCommand(query, con);
        return cmd.ExecuteNonQuery();
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        switch (((Button)sender).CommandArgument.ToString())
        {
            case "first":
                GridView1.PageIndex = 0;
                break;
            case "last":
                GridView1.PageIndex = GridView1.PageCount - 1;
                break;
            case"prev":
                GridView1.PageIndex = GridView1.PageIndex - 1;
                break;
            case"next":
                GridView1.PageIndex = GridView1.PageIndex + 1;
                break;
        }
        bind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string id = GridView1.DataKeys[e.RowIndex]["ID"].ToString();
        string fname=((TextBox)GridView1.Rows[e.RowIndex].Cells[1].FindControl("TextBox1")).Text;
        string city = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].FindControl("TextBox2")).Text;
        string phone = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].FindControl("TextBox3")).Text;
        string query="update flash set ID='"+id+"',fenlei1='"+fname+"',fenlei2='"+city+"',mingcheng='"+phone+"'where ID='"+id+"'";
        if (cmd(query) > 0)
        {
            GridView1.EditIndex = -1;
            bind();
        }

    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string id = GridView1.DataKeys[e.RowIndex]["ID"].ToString();
        string query="delete from flash where ID='"+id+"'";
        if (cmd(query) > 0)
        {
            bind();
        }
    }
}