当前文件： ComplexVote/user.aspx.cs[4K，2009-6-12 11:37:11]，打开代码结构图

		            
  1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Drawing;
  6using System.Web;
  7using System.Web.SessionState;
  8using System.Web.UI;
  9using System.Web.UI.WebControls;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12
 13namespace vote
 14...{
 15    /**//// <summary>
 16    /// user 的摘要说明。
 17    /// </summary>
 18    public partial class user : System.Web.UI.Page
 19    ...{
 20    
 21        protected void Page_Load(object sender, System.EventArgs e)
 22        ...{
 23            // 在此处放置用户代码以初始化页面
 24            if(!Page.IsPostBack)
 25            ...{
 26                this.fill();
 27            }
 28            
 29        }
 30
 31        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 32        override protected void OnInit(EventArgs e)
 33        ...{
 34            //
 35            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 36            //
 37            InitializeComponent();
 38            base.OnInit(e);
 39        }
 40        
 41        /**//// <summary>
 42        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 43        /// 此方法的内容。
 44        /// </summary>
 45        private void InitializeComponent()
 46        ...{    
 47            this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
 48            this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
 49            this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
 50            this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand);
 51            this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
 52            this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
 53            this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
 54
 55        }
 56        #endregion
 57
 58        private void fill()
 59        ...{//做一个绑定方法,因为页内有多次绑定
 60            this.DataGrid1.DataSource=db.fill("select * from admin");
 61            this.DataGrid1.DataKeyField="id";//方便后面的删改
 62            this.DataBind();
 63        }
 64        private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 65        ...{//取消编辑
 66            this.DataGrid1.EditItemIndex=-1;//编辑列的索引设置为-1,表示一个都没有选
 67            this.fill();//重新绑定
 68        }
 69
 70        private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 71        ...{//选择编辑
 72            this.DataGrid1.EditItemIndex=e.Item.ItemIndex;//设置编辑的索引为当前选中的ID
 73            this.fill();
 74        }
 75
 76        private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 77        ...{//更新操作
 78            if(this.IsValid)
 79            ...{//因为单元格中的文本框是我们不知道的，所以采用这种方式去找，然后强制类型转换成textbox，再提出他的值
 80                string id=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
 81                string name=((TextBox)(e.Item.Cells[1].Controls[1])).Text.ToString();
 82                string pwd=((TextBox)(e.Item.Cells[2].Controls[1])).Text.ToString();
 83                string qx=((DropDownList)(e.Item.Cells[3].Controls[1])).SelectedValue.ToString();
 84                string query="update admin set name='"+name+"',pwd='"+pwd+"',qx='"+qx+"' where id="+id+"";
 85                db.update(query);
 86                this.DataGrid1.EditItemIndex=-1;
 87                this.fill();
 88            }
 89            
 90        }
 91
 92        private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 93        ...{//删除操作
 94            string id=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
 95            db.delete("delete from admin where id="+id+"");
 96            this.fill();
 97        }
 98
 99        private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
100        ...{//鼠标动作
101            if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)//如果选中项是列表项，而不是头或者脚什么的
102            ...{
103                e.Item.Attributes.Add("onmouseover","c=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
104                e.Item.Attributes.Add("onmouseout","this.style.backgroundColor=c");
105                ((LinkButton)(e.Item.Cells[5].Controls[0])).Attributes.Add("onclick","return confirm('确认删除？')");
106            }
107        }
108
109        private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
110        ...{//分页操作
111            this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
112            fill();
113        }
114
115        private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
116        ...{//排序操作
117            if(ViewState["Order"]==null)
118            ...{
119                ViewState["Order"]="ASC";
120            }
121            else
122            ...{
123                if(ViewState["Order"].ToString()=="ASC")
124                ...{
125                    ViewState["Order"]="DESC";
126                }
127                else
128                ...{
129                ViewState["Order"]="ASC";
130                }
131            }
132            SqlConnection con=db.con();
133            con.Open();
134            SqlDataAdapter sda=new SqlDataAdapter();
135            sda.SelectCommand=new SqlCommand("select * from admin",con);
136            DataSet ds=new DataSet();
137            sda.Fill(ds,"user");
138            ds.Tables["user"].DefaultView.Sort=e.SortExpression+" "+ViewState["Order"].ToString();
139            this.DataGrid1.DataSource=ds.Tables["user"].DefaultView;
140            this.DataGrid1.DataBind();
141        }
142    }
143}
144