用Datalist配合RadioButtonList实现单项选择题

来源：互联网发布：怎么才能成为淘宝客编辑：程序博客网时间：2024/05/16 09:21

数据库结构：

表Question

QuestionID 索引自动编号

Question 问题内容

表Answers

AnswerID索引自动编号

QuestionID 问题ID

Option 答案内容

suoyin 答案索引（ABCD）

default.aspx主要代码：

default.aspx.cs主要代码:

protected void Page_Load(object sender, EventArgs e){ if (!IsPostBack) { bindData(); }}void bindData(){ string sql = "select * from Question"; DataSet ds = DB.reDs(sql, "table1"); DataTable dt = ds.Tables["table1"]; DataList1.DataSource = dt; DataList1.DataKeyField = "QuestionID"; DataList1.DataBind();}protected void Item_Bound(Object sender, DataListItemEventArgs e){ if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { RadioButtonList rbl = (RadioButtonList)e.Item.FindControl("RadioButtonList1"); string sql = "select * from Answers where QuestionID='"+DataList1.DataKeys[e.Item.ItemIndex]+"'"; // Response.Write(sql); DataSet ds = DB.reDs(sql, "table2"); DataTable dt = ds.Tables["table2"]; rbl.DataSource = dt; rbl.DataTextField = "Option"; rbl.DataValueField = "suoyin"; rbl.DataBind(); }}protected void DataList1_ItemCommand(Object sender, CommandEventArgs e){ if (e.CommandName=="UpdateIt") { foreach (DataListItem oDataListItem in DataList1.Items) { RadioButtonList rbtl = (RadioButtonList)oDataListItem.FindControl("RadioButtonList1"); string str = rbtl.SelectedValue.ToString(); string qid = DataList1.DataKeys[oDataListItem.ItemIndex].ToString(); string sql = "insert into UserCorrect (QuestionID,Answer,username) values ('"+qid+"','"+str+"','shortail')"; DB.ExSql(sql); DB.Msg("提交成功！"); } }}