girdview.cs增删改查.docVIP

public partial class 树控件t_TreeViewList : System.Web.UI.Page {private static string deptiD = ; protected void Page_Load(object sender, EventArgs e) { if (Request[ID] != null) {deptiD = Request.QueryString[ID];} else { deptiD = 0;} if (!IsPostBack) { bind(); }} /// 在单击 GridView 控件内某一行的 Delete 按钮（其 CommandName 属性设置为Delete的按钮）时发生，但在 GridView 控件从数据源删除记录之前。此事件通常用于取消删除操作。 /// param name=sender/param /// param name=e/param protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string sql = select * from dept where Orderbyid = + deptiD + ; DataSet ds = Common.dataSet(sql); if (ds != null ds.Tables.Count 0 ds.Tables[0].Rows.Count 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), , scriptalert(该部门下还有科室，不允许删除！);/script);} else {string sqlStr = delete from dept where ID= + Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value) + ; Common.ExecuteSql(sqlStr); Page.ClientScript.RegisterStartupScript(this.GetType(), , scriptalert(删|除成功);window.parent.ReflashTreeView();/script);} bind();} /// summary ///在单击 GridView 控件内某一行的 Update 按钮（其 CommandName 属性设置为Update的按钮）时发生，但在 GridView 控件更新记录之前。此事件通常用于取消更新操作。 /// /summary /// param name=sender/param /// param name=e/param protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {string ID = GridView1.DataKeys[e.RowIndex].Value.ToString(); string Emp_deptName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim(); string sqlStr = update dept set deptNam= + Emp_deptName + where ID= + ID + ; Common.ExecuteSql(sqlStr); GridView1.EditIndex = -1; bind();} /// summary ///在单击 GridView 控件内某一行的 Edit 按钮（其 CommandName 属性设置为“Edit”的按钮）时发生，但在 GridView 控件进入编辑模式之前。此事件通常用于取消编辑操作。 /// /summary /// param name=sender/param /// param name=e/param