protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dataconn.ecadabind(gvExamResu, "select * from chengji_chaxun_view ORDER BY ID DESC");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtSelect.Text == "")
{
dataconn.ecadabindinfostring(gvLessInfo, "Select * From kecheng_zhuanye_view ORDER BY ID DESC", "ID");
}
else
{
dataconn.ecadabind(gvLessInfo, "Select * From kecheng_zhuanye_view Where "
+ ddlLessName.SelectedValue + " Like '%" + txtSelect.Text + "%'");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtSelect.Text == "")
{
//调用公共类中的ecadabindinfostring方法，实现管理员数据的绑定
dataconn.ecadabindinfostring(gvAdminInfo, "select * from tb_Teacher ORDER BY ID DESC", "ID");
}
else
{
//调用公共类中的ecadabind方法，实现管理员数据的查询
dataconn.ecadabind(gvAdminInfo, "Select * From tb_Teacher Where "
+ ddlAdminName.SelectedValue + " Like '%" + txtSelect.Text + "%'");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtSelect.Text == "")
{
//调用公共类中的ecadabindinfostring方法，绑定数据库中信息
dataconn.ecadabindinfostring(gvStuExam, "select * from tb_StuResult ORDER BY res_Id DESC", "res_id");
}
else
{
//调用公共类中的ecadabind方法，绑定查询信息
dataconn.ecadabind(gvStuExam, "Select * From tb_StuResult Where " + ddlStuID.SelectedValue
+ " Like '%" + txtSelect.Text + "%'");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtSelect.Text == "")
{
//调用ecadabindinfostring方法绑定数据库信息
dataconn.ecadabindinfostring(gvQueInfo, "Select * From kecheng_taoti_view ORDER BY Id DESC", "ID");
}
else
{
//调用ecadabind方法绑定查询信息
dataconn.ecadabind(gvQueInfo, "Select * From kecheng_taoti_view Where "
+ ddlQueName.SelectedValue + " Like '%" + txtSelect.Text + "%'");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtSelect.Text == "")
{
//调用公共类中的ecadabindinfostring方法，绑定数据库信息
dataconn.ecadabindinfostring(gvExamTitle, "Select * From Timu_Taoti_Kcheng_view ORDER BY Id DESC", "ID");
}
else
{
//调用公共类中的ecadabind方法，绑定查询信息
dataconn.ecadabind(gvExamTitle, "Select * From Timu_Taoti_Kcheng_view Where "
+ ddlType.SelectedValue + " Like '%" + txtSelect.Text + "%'");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtSelect.Text == "")
{
//调用公共类中的ecadabindinfostring方法，绑定数据库信息
dataconn.ecadabindinfostring(gvProInfo, "select * from tb_Profession ORDER BY ID DESC", "ID");
}
else
{
//调用公共类中的ecadabind方法，绑定查询信息
dataconn.ecadabind(gvProInfo, "Select * from tb_Profession Where "
+ ddlProName.SelectedValue + " Like '%" + txtSelect.Text + "%'");
}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvStuInfo.PageIndex = e.NewPageIndex;
dataconn.ecadabind(gvStuInfo, "Select * From stu_zhuanye_view Where "
+ ddlStuID.SelectedValue + " Like '%" + txtSelect.Text + "%'");
}
