//保存修改 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString()); using (var context = new DataContext.StuDBContext()) { //查询出要修改这条记录 var p = context.Students.Find(id); //读出gridview中用户编辑的字段,给每个允许修改的实体属性赋值 //获取用户编辑的这一行 var row = GridView1.Rows[e.RowIndex]; var sn = (row.Cells[0].Controls[0] as TextBox).Text.Trim(); var name = (row.Cells[1].Controls[0] as TextBox).Text.Trim(); var phone = (row.Cells[2].Controls[0] as TextBox).Text.Trim(); var department = Guid.Parse(((DropDownList)row.FindControl("editdepartment")).SelectedValue); p.StudentCode = sn; p.Name = name; p.Phone = phone; p.Department = context.Departments.Find(department); context.SaveChanges(); } GridView1.EditIndex = -1; _getData(); }
//保存修改 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //查询出该记录的主键 var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString()); using (var context = new DataContext.StuDBContext()) { var s = context.Students.Find(id); //读出Gridview中用户编辑的字段,给每个允许修改的实体属性赋值 //获取用户编辑的这一行 var row = GridView1.Rows[e.RowIndex]; var sn = (row.Cells[0].Controls[0] as TextBox).Text.Trim(); var name = (row.Cells[1].Controls[0] as TextBox).Text.Trim(); var add = (row.Cells[2].Controls[0] as TextBox).Text.Trim(); var Departmentid = Guid.Parse(((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DdlDepartment")).SelectedValue); s.Department = context.DepartMents.Find(Departmentid); s.StudentNo = sn; s.FullName = name; s.Address = add; context.SaveChanges(); } GridView1.EditIndex = -1; _getData(); }
//删除 private void NewMethod(GridViewDeleteEventArgs e) { var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString()); using (var context = new DataContext.StuDBContext()) { var delstu = context.Students.Find(id); context.Students.Remove(delstu); context.SaveChanges(); } }
//删除 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString()); using (var context = new DataContext.StuDBContext()) { //删除这条记录 var delstudent = context.Students.Find(id); context.Students.Remove(delstudent); context.SaveChanges(); } _getData(); }