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();
}
}