private void Page_Load(object sender, System.EventArgs e)btnsubmit=new Button();
btnsubmit.Attributes["runat"]="server";
System.Data.SqlClient.SqlConnection con=new SqlConnection(Session["cn"].ToString());
con.Open();
string sqlc="select max(shijuanhao) from NeiCeShiJuan";
num=Base.ExecuteSql4Value(sqlc); int []nm=new int[4];
string sqla="select tihao from NeiCeShiJuan where shijuanhao='"+num+"'";
System.Data.SqlClient.SqlCommand cmd=new SqlCommand(sqla,con);
System.Data.SqlClient.SqlDataReader dr1=cmd.ExecuteReader();
mystr1 +="<h1 align=center valign=buttom>"+Session["kemu"]+"内测题</h1 ><br><hr>";
str0+="<hr>";
btnsubmit=new Button();
btnexit=new Button();
btnsubmit.Text="提交";
btnexit.Text="取消";
while(dr1.Read())
{
System.Data.SqlClient.SqlConnection con1=new SqlConnection(Session["cn"].ToString());
con1.Open();
sqlb="select * from NeiCeTiKu where tihao='"+Convert.ToInt32(dr1["tihao"])+"'";
//当NeiCeTiKu tihao=NeiCeShiJuan 中的tihao时把其他这个题号相关的内容显示出来
System.Data.SqlClient.SqlCommand cmd1=new SqlCommand(sqlb,con1);
SqlDataReader dr=cmd1.ExecuteReader();
while(dr.Read())
{
if(dr["leixing"].ToString()=="r")
{
typestr="单选";
}
else
{
typestr="多选";
}
subject=dr["kemu"].ToString();
mystr +=j.ToString()+" " + dr["neirong"] +" "+typestr + "<br>";
mystr +="A  " + dr["xuanxiangA"].ToString() +"<br> B  "+ dr["xuanxiangB"].ToString()+"<br> C  " +dr["xuanxiangC"].ToString() +"<br> D  " +dr["xuanxiangD"].ToString()+"<br> E  " +dr["xuanxiangE"].ToString()+"<br>";
mystr+="<br>答案<br>";
label1.Text=mystr1;
mylabel.Text=mystr;
cell.Controls.Add(label1);
cell.Controls.Add(mylabel);
if (dr["leixing"].ToString()=="r")
{
RadioButtonList radio=new RadioButtonList();
radio.RepeatDirection=RepeatDirection.Horizontal;
radio.ID="mycontrol"+ j.ToString();
radio.Items.Add("A");
radio.Items.Add("B");
radio.Items.Add("C");
radio.Items.Add("D");
radio.Items.Add("E");
cell.Controls.Add(radio);//单选的选项ABCDE
}
else
{
CheckBoxList check =new CheckBoxList();
check.RepeatDirection=RepeatDirection.Horizontal;
check.ID="mycontrol" +j.ToString();
check.Items.Add("A");
check.Items.Add("B");
check.Items.Add("C");
check.Items.Add("D");
check.Items.Add("E");
cell.Controls.Add(check);//复选的选项ABCDE
}
label0.Text=str0;
cell.Controls.Add(label0);
cell.Controls.Add(btnsubmit);
this.btnsubmit.Click+=new System.EventHandler(this.btnsubmit_Click);
cell.Controls.Add(btnexit);
row.Cells.Add(cell);
Table1.Rows.Add(row);
j+=1;
}
}//我在做一个在线考试系统,这里是动态生成的试卷,
合并多个表的数据的方法有三种 多选
A 联合
B 子查询
C 联接
D 角色
E 答案
4 子句可以与子查询一起使用检查行或列是否存在 单选
A UNION
B EXITSTS
C DISTINCT
D COMPUTE BY
E 答案
A B C D E --------------------------------------------------------------------------------
//最后一道题的位置是正确的,前面几个都不正确,答案下面都单选或者多选按纽的在这里没有显示出来
//我的QQ是349688626,希望您给点意见!有人说女孩不适合学习编程,但我不认为会比别人差!期待您的建议!!!
btnsubmit.Attributes["runat"]="server";
System.Data.SqlClient.SqlConnection con=new SqlConnection(Session["cn"].ToString());
con.Open();
string sqlc="select max(shijuanhao) from NeiCeShiJuan";
num=Base.ExecuteSql4Value(sqlc); int []nm=new int[4];
string sqla="select tihao from NeiCeShiJuan where shijuanhao='"+num+"'";
System.Data.SqlClient.SqlCommand cmd=new SqlCommand(sqla,con);
System.Data.SqlClient.SqlDataReader dr1=cmd.ExecuteReader();
mystr1 +="<h1 align=center valign=buttom>"+Session["kemu"]+"内测题</h1 ><br><hr>";
str0+="<hr>";
btnsubmit=new Button();
btnexit=new Button();
btnsubmit.Text="提交";
btnexit.Text="取消";
while(dr1.Read())
{
System.Data.SqlClient.SqlConnection con1=new SqlConnection(Session["cn"].ToString());
con1.Open();
sqlb="select * from NeiCeTiKu where tihao='"+Convert.ToInt32(dr1["tihao"])+"'";
//当NeiCeTiKu tihao=NeiCeShiJuan 中的tihao时把其他这个题号相关的内容显示出来
System.Data.SqlClient.SqlCommand cmd1=new SqlCommand(sqlb,con1);
SqlDataReader dr=cmd1.ExecuteReader();
while(dr.Read())
{
if(dr["leixing"].ToString()=="r")
{
typestr="单选";
}
else
{
typestr="多选";
}
subject=dr["kemu"].ToString();
mystr +=j.ToString()+" " + dr["neirong"] +" "+typestr + "<br>";
mystr +="A  " + dr["xuanxiangA"].ToString() +"<br> B  "+ dr["xuanxiangB"].ToString()+"<br> C  " +dr["xuanxiangC"].ToString() +"<br> D  " +dr["xuanxiangD"].ToString()+"<br> E  " +dr["xuanxiangE"].ToString()+"<br>";
mystr+="<br>答案<br>";
label1.Text=mystr1;
mylabel.Text=mystr;
cell.Controls.Add(label1);
cell.Controls.Add(mylabel);
if (dr["leixing"].ToString()=="r")
{
RadioButtonList radio=new RadioButtonList();
radio.RepeatDirection=RepeatDirection.Horizontal;
radio.ID="mycontrol"+ j.ToString();
radio.Items.Add("A");
radio.Items.Add("B");
radio.Items.Add("C");
radio.Items.Add("D");
radio.Items.Add("E");
cell.Controls.Add(radio);//单选的选项ABCDE
}
else
{
CheckBoxList check =new CheckBoxList();
check.RepeatDirection=RepeatDirection.Horizontal;
check.ID="mycontrol" +j.ToString();
check.Items.Add("A");
check.Items.Add("B");
check.Items.Add("C");
check.Items.Add("D");
check.Items.Add("E");
cell.Controls.Add(check);//复选的选项ABCDE
}
label0.Text=str0;
cell.Controls.Add(label0);
cell.Controls.Add(btnsubmit);
this.btnsubmit.Click+=new System.EventHandler(this.btnsubmit_Click);
cell.Controls.Add(btnexit);
row.Cells.Add(cell);
Table1.Rows.Add(row);
j+=1;
}
}//我在做一个在线考试系统,这里是动态生成的试卷,
合并多个表的数据的方法有三种 多选
A 联合
B 子查询
C 联接
D 角色
E 答案
4 子句可以与子查询一起使用检查行或列是否存在 单选
A UNION
B EXITSTS
C DISTINCT
D COMPUTE BY
E 答案
A B C D E --------------------------------------------------------------------------------
//最后一道题的位置是正确的,前面几个都不正确,答案下面都单选或者多选按纽的在这里没有显示出来
//我的QQ是349688626,希望您给点意见!有人说女孩不适合学习编程,但我不认为会比别人差!期待您的建议!!!
<TABLE class="Table" cellSpacing="1" cellPadding="3" width="100%" border="0">
<TR>
<TD class="TableHeader" colSpan="4">
<asp:textbox class="Text" id="txtFoodsChiName" MaxLength="120" runat="server" Width="100%"></asp:textbox>
</TD>
</TR>
<TR>
<TD class="TableContent" width="30%" colspan = "3">
<asp:textbox class="Text" id="txtFoodsChiName" MaxLength="120" runat="server" Width="100%"></asp:textbox>
</TD>
</TR>
</Table