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