gridview经典大放松

gridview经典大放松

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 Gridview : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       //这个肯定大家都知道
        bind();
    }
    //不要问我为什么,自己看
    protected void bind()
    {
        SqlConnection con = db.create();
        con.Open();
        SqlCommand cmd = new SqlCommand("select 管理员帐号,管理员密码,管理员身份,管理员单位,管理员职位,管理员名字,电话,联系方式,有无权限 from 管理员信息表", con);
        DataSet ds = new DataSet();
        SqlDataAdapter ad = new SqlDataAdapter(cmd);
        ad.Fill(ds,"table");
        //SqlDataReader sdr = cmd.ExecuteReader();
        //下面是2个方法,嘿嘿.
        this.GridView1.DataSource = ds.Tables["table"];
        //this.GridView1.DataSource=ds.Tables[0];0是表的索引
        this.GridView1.DataBind();
        con.Close();
    }
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            //增加表头
            TableCellCollection tcHeader = e.Row.Cells;
            tcHeader.Clear();
            tcHeader.Add(new TableHeaderCell());
            tcHeader[0].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[0].Attributes.Add("colspan", "9"); //跨Column
            tcHeader[0].Attributes.Add("Align", "center");
            tcHeader[0].Text = "管理员基本信息</th></tr><tr>";
            //为每个字段增加字段名
            tcHeader.Add(new TableHeaderCell());
            tcHeader[1].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[1].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[1].Text = "管理员帐号";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[2].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[2].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[2].Text = "管理员密码";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[3].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[3].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[3].Text = "管理员身份";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[4].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[4].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[4].Text = "管理员单位";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[5].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[5].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[5].Text = "管理员职位";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[6].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[6].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[6].Text = "管理员名字";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[7].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[7].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[7].Text = "电话";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[8].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[8].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[8].Text = "联系方式";
            tcHeader.Add(new TableHeaderCell());
            tcHeader[9].Attributes.Add("style", "color:#FFFFCC");
            tcHeader[9].Attributes.Add("bgcolor", "#3399cc");
            tcHeader[9].Text = "有无权限";
            
        }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        //编辑某行
        GridView1.EditIndex = e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //鼠标经过时，行背景色变
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");
            //鼠标移出时，行背景色变
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");
        }
    }
    protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
        //更新语句
    }
    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].Value.ToString();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        bind();
    }
}