protected void init()//初始化数据 { GridView1.DataSource = DBHelper.GetDataTable("select * from Pro_Units"); GridView1.DataBind(); }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {//编辑 GridView1.EditIndex = e.NewEditIndex; init(); }
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {//取消 GridView1.EditIndex = -1; init(); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {//更新 string str = GridView1.Rows[e.RowIndex].Cells[0].Text.Trim(); string name = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.Trim(); DBHelper.ExecutCommand("UPDATE [Pro_Units] SET [uintsName] ='"+name+"' WHERE id=" + str); GridView1.EditIndex = -1; init(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {//删除 string str = GridView1.Rows[e.RowIndex].Cells[0].Text.Trim(); DBHelper.ExecutCommand("DELETE FROM [Pro_Units] WHERE id=" + str); GridView1.EditIndex = -1; init(); }