protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string id = GridViewTeacher.DataKeys[e.RowIndex].Value.ToString(); bool success = dao.DeleteBody(id, 2); if (success) { Response.Write("<script>alert('删除成功!')</script>"); //刷新该页面 SqlConnection sqlConnection = SqlTools.Connection(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select teacher.*,Dept.Name as'deptname' from teacher left join dept on Dept.ID=Teacher.Department", sqlConnection); DataSet dataSet = new DataSet(); GridViewTeacher.DataKeyNames = new string[] { "id" }; sqlDataAdapter.Fill(dataSet); GridViewTeacher.DataSource = dataSet; GridViewTeacher.DataBind(); sqlConnection.Close(); } else { Response.Write("<script>alert('删除失败!')</script>"); } }
/* * get and bind the data to gridviewteacher */ private void GetData() { var teacher = from t in pub.Teacher join d in pub.Department on t.DepartmentId equals d.DepartmentId select new { t.TeacherId, t.Name, DepartmentName = d.ChinesaeName, t.Introduction, t.JobNumber }; GridViewTeacher.DataKeyNames = new string[] { "TeacherId" }; GridViewTeacher.DataSource = teacher.ToList(); GridViewTeacher.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlConnection sqlConnection = SqlTools.Connection(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select teacher.*,Dept.Name as'deptname' from teacher left join dept on Dept.ID=Teacher.Department", sqlConnection); DataSet dataSet = new DataSet(); GridViewTeacher.DataKeyNames = new string[] { "id" }; sqlDataAdapter.Fill(dataSet); GridViewTeacher.DataSource = dataSet; GridViewTeacher.DataBind(); sqlConnection.Close(); }
public void getTeacherData() { GridViewTeacher.DataSource = lbManageEntity.showPandingTeacher(); GridViewTeacher.DataBind(); GridViewTeacherLogin.DataSource = lbManageEntity.showPandingTeacherLib(); GridViewTeacherLogin.DataBind(); gridViewLibraray.Visible = false; gridViewUniversity.Visible = false; GridViewTeacher.Visible = true; GridViewTeacherLogin.Visible = true; PanelBook.Visible = false; }
protected void bindGrid() { ListToTable lsttodt = new ListToTable(); var lst = teacherRepository.GetTeacherList(); DataTable dt = lsttodt.ToDataTable(lst); if (dt != null && dt.Rows.Count > 0) { GridViewTeacher.DataSource = dt; GridViewTeacher.DataBind(); } else { GridViewTeacher.DataBind(); } }