根据下面的case 1,case 2和数据库tb_Questions表的字段建立一个变量记录产生的试题的唯一编号
case 1:
SqlDataAdapter myadapter1 = new SqlDataAdapter("select * "
+ "from tb_Questions where que_type='单选题'and que_lessonid='"
+ dd1 + "'and que_taotiid='" + dd2 + "'order by id desc", con);
DataSet myds1 = new DataSet();
myadapter1.Fill(myds1);
DataList1.DataSource = myds1;
DataList1.DataBind();
//生成单选题题号
for (int tID1 = 1; tID1 <= DataList1.Items.Count; tID1++)
{
Label lblSelect = (Label)DataList1.Items[tID1 - 1].FindControl("Label2");
lblSelect.Text = tID1.ToString() + "、";
}
break;
case 2:
SqlDataAdapter myadapter3 = new SqlDataAdapter("select id,que_answer"
+ " from tb_Questions where que_type='单选题'and que_lessonid="
+ dd1 + " and que_taotiid=" + dd2 + " order by id desc", con);
DataSet myds3 = new DataSet();
myadapter3.Fill(myds3);
DataRow[] row1 = myds3.Tables[0].Select();
//计算单选题成
foreach (DataRow answer1 in row1)
{
int_row1 += 1;
if (int_row1<= 3)
{
RadioButtonList rbl = (RadioButtonList)(DataList1.Items[int_row1 - 1].FindControl("RadioButtonList1"));
if (rbl.SelectedValue == "")
{
this.lblSel.Text = "0";
}
else
{
if (answer1["que_answer"].ToString().Trim() == rbl.SelectedValue.ToString().Trim())
{
int_row1Point += 40 / DataList1.Items.Count;
this.lblSel.Text = int_row1Point.ToString();
}
}
}
}
break;
case 1:
SqlDataAdapter myadapter1 = new SqlDataAdapter("select * "
+ "from tb_Questions where que_type='单选题'and que_lessonid='"
+ dd1 + "'and que_taotiid='" + dd2 + "'order by id desc", con);
DataSet myds1 = new DataSet();
myadapter1.Fill(myds1);
DataList1.DataSource = myds1;
DataList1.DataBind();
//生成单选题题号
for (int tID1 = 1; tID1 <= DataList1.Items.Count; tID1++)
{
Label lblSelect = (Label)DataList1.Items[tID1 - 1].FindControl("Label2");
lblSelect.Text = tID1.ToString() + "、";
}
break;
case 2:
SqlDataAdapter myadapter3 = new SqlDataAdapter("select id,que_answer"
+ " from tb_Questions where que_type='单选题'and que_lessonid="
+ dd1 + " and que_taotiid=" + dd2 + " order by id desc", con);
DataSet myds3 = new DataSet();
myadapter3.Fill(myds3);
DataRow[] row1 = myds3.Tables[0].Select();
//计算单选题成
foreach (DataRow answer1 in row1)
{
int_row1 += 1;
if (int_row1<= 3)
{
RadioButtonList rbl = (RadioButtonList)(DataList1.Items[int_row1 - 1].FindControl("RadioButtonList1"));
if (rbl.SelectedValue == "")
{
this.lblSel.Text = "0";
}
else
{
if (answer1["que_answer"].ToString().Trim() == rbl.SelectedValue.ToString().Trim())
{
int_row1Point += 40 / DataList1.Items.Count;
this.lblSel.Text = int_row1Point.ToString();
}
}
}
}
break;
解决方案 »
- 可有办法保存上次操作的控件?
- sql如何批量更新
- 配置文件问题:在应用程序级别之外使用注册为 allowDefinition='MachineToApplication' 的节是错误的 asp.net
- vs2005从编辑页面定位到解决方案资源管理器
- formview中插入数据之后希望页面不转走,还在插入模式页面,能实现吗?
- 如何检索出表中不同时间段插入的记录?
- 遭遇奇怪问题:asp.net调试时监视窗口中无法获取部分对象的属性值,甚至对已经初始化的变量显示未定义
- 请问static变量的范围
- winform界面假死
- 水晶报表参数传递问题
- Entity framework
- textbox RequiredFieldValidator 验证加入ValidationGroup 无法验证
[id] [bigint] NOT NULL ,
[que_subject] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[que_type] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[que_joindate] [datetime] NULL ,
[que_lessonid] [int] NULL ,
[que_professionid] [int] NULL ,
[que_taotiid] [bigint] NULL ,
[optionA] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[optionB] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[optionC] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[optionD] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[que_answer] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[note] [varchar] (50) ) ].Quote=引用 1 楼 rpwlp888 的回复:]
tb_Questions表里增加一个自动增量的字段.
[/Quote]