protected void ImageButton1_Click(object sender, ImageClickEventArgs e) //查询 { if (TextBox1.Text == "") { dataconn.bindinfostring(GridView1, "select * from student_score where ID='" + Session["ID"] + "'", "ID"); } else { if (RadioButton1.Checked) { dataconn.bind(GridView1, "select * from student_score where ID='" + Session["ID"] + "'and c_name Like'%" + TextBox1.Text + "%'"); } else if (RadioButton2.Checked) { dataconn.bind(GridView1, "select * from student_score where ID='" + Session["ID"] + "'and PaperName Like'%" + TextBox1.Text + "%'"); } else if (RadioButton3.Checked) { dataconn.bind(GridView1, "select * from student_score where ID='" + Session["ID"] + "'and Score Like'%" + TextBox1.Text + "%'"); } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('请选择查询类型!');</script>"); } } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { if (TextBox1.Text == "") { dataconn.bindinfostring(GridView1, "select * from Student order by ID DESC", "ID"); } else { dataconn.bind(GridView1, "select * from Student where " + DropDownList1.SelectedValue + " Like'%" + TextBox1.Text + "%'"); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { if (TextBox1.Text == "") { dataconn.bindinfostring(GridView1, "select * from Course where teacher_id='" + Session["ID"] + "'", "c_name"); } else { dataconn.bind(GridView1, "select * from Course where teacher_id='" + Session["ID"] + "'and " + DropDownList1.SelectedValue + " Like '%" + TextBox1.Text + "%'"); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { if (TextBox1.Text == "") { dataconn.bindinfostring(gvQueInfo, "select * from JudgeProblem where c_id in(select c_id from Course where teacher_id='" + Session["ID"] + "') order by ID DESC", "ID"); } else { dataconn.bind(gvQueInfo, "select * from JudgeProblem where c_id in(select c_id from Course where teacher_id='" + Session["ID"] + "') and " + DropDownList1.SelectedValue + " Like'%" + TextBox1.Text + "%'"); } }
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; dataconn.bind(GridView1, "select * from Teacher order by id DESC"); }