protected void Button_preview_Click(object sender, EventArgs e) { add.Style.Add("display", "none"); //不显示 preview_div.Style.Add("display", "block"); //显示 double num = Convert.ToDouble(Label21.Text); if (num <= 100) { int d1 = int.Parse(SingleNum.Text.Trim()) + int.Parse(SingleNum1.Text.Trim()) + int.Parse(SingleNum2.Text.Trim()); string GridView1Str = "select top " + d1 + " * from SingleProblem where c_id='" + ddlCourse.SelectedValue + " ' order by newid()"; //根据参数设置查询单选题Sql语句 DataSet ds1 = db.GetDataSetSql(GridView1Str); //调用DataBase类方法GetDataSetSql方法查询数据 GridView1.DataSource = ds1.Tables[0].DefaultView; //为单选题GridView控件指名数据源 GridView1.DataBind(); //绑定数据 int d2 = int.Parse(MultiNum.Text.Trim()) + int.Parse(MultiNum1.Text.Trim()) + int.Parse(MultiNum2.Text.Trim()); string GridView2Str = "select top " + d2 + " * from MultiProblem where c_id='" + ddlCourse.SelectedValue + " ' order by newid()"; //根据参数设置查询多选题Sql语句 DataSet ds2 = db.GetDataSetSql(GridView2Str); //调用DataBase类方法GetDataSetSql方法查询数据 GridView2.DataSource = ds2.Tables[0].DefaultView; //为多选题GridView控件指名数据源 GridView2.DataBind(); //绑定数据 int d3 = int.Parse(JudgeNum.Text.Trim()) + int.Parse(JudgeNum1.Text.Trim()); string GridView3Str = "select top " + d3 + " * from JudgeProblem where c_id='" + ddlCourse.SelectedValue + " ' order by newid()"; //根据参数设置查询判断题Sql语句 DataSet ds3 = db.GetDataSetSql(GridView3Str); //调用DataBase类方法GetDataSetSql方法查询数据 GridView3.DataSource = ds3.Tables[0].DefaultView; //为判断题GridView控件指名数据源 GridView3.DataBind(); //绑定数据 } else { Response.Write("<script>alert('分数大于了100分,请重新选择!')</script>"); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { double num = Convert.ToDouble(Label21.Text); if (num <= 100) { string GridView1Str = "select top " + int.Parse(SingleNum.Text.Trim()) + " * from SingleProblem where c_id='" + ddlCourse.SelectedValue + " ' order by newid()"; //根据参数设置查询单选题Sql语句 DataSet ds1 = db.GetDataSetSql(GridView1Str); //调用DataBase类方法GetDataSetSql方法查询数据 GridView1.DataSource = ds1.Tables[0].DefaultView; //为单选题GridView控件指名数据源 GridView1.DataBind(); //绑定数据 string GridView2Str = "select top " + int.Parse(MultiNum.Text.Trim()) + " * from MultiProblem where c_id='" + ddlCourse.SelectedValue + " ' order by newid()"; //根据参数设置查询多选题Sql语句 DataSet ds2 = db.GetDataSetSql(GridView2Str); //调用DataBase类方法GetDataSetSql方法查询数据 GridView2.DataSource = ds2.Tables[0].DefaultView; //为多选题GridView控件指名数据源 GridView2.DataBind(); //绑定数据 string GridView3Str = "select top " + int.Parse(JudgeNum.Text.Trim()) + " * from JudgeProblem where c_id='" + ddlCourse.SelectedValue + " ' order by newid()"; //根据参数设置查询判断题Sql语句 DataSet ds3 = db.GetDataSetSql(GridView3Str); //调用DataBase类方法GetDataSetSql方法查询数据 GridView3.DataSource = ds3.Tables[0].DefaultView; //为判断题GridView控件指名数据源 GridView3.DataBind(); //绑定数据 ImageButton2.Visible = true; } else { Response.Write("<script>alert('分数大于了100分,请重新选择!')</script>"); } }