如何在Datagrid中呈现选择题(选项个数不定)(采用我的毕设数据库)
1.建立一个DataGrid取名DataGrid1,里面有题目ID(QuestionID,设置属性不可见)、题号(QSequence)、分 值(Mark)、题干(QuestionText)和选项五个模板列。其中除了选项模板列以外都要添加ItemTemplate内容(Lable控件)并 且绑定数据。
2.在.cs文件中编写DataGrid绑定函数BindGrid()。
private void BindGrid()
{
string strConn=System.Configuration.ConfigurationSettings.AppSettings["database"];
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
SqlCommand cm=new SqlCommand("select Paper_Question.QuestionID,Paper_Question.QSequence,Mark,Question.QuestionText from Paper_Question,Question where Paper_Question.QuestionID=Question.QuestionID and Question.QuestionType="+Typeid.ToString()+"and Paper_Question.PaperID="+Paperid.ToString(),cn);
SqlDataReader dr=cm.ExecuteReader();
DataGrid1.DataSource=dr;
DataGrid1.DataBind();//数据绑定
cn.Close();
}
从BindGrid()函数可以看出,没有涉及对选项和数据操作。
3.生成DataGrid1的ItemDataBound事件。获取当前记录的题目ID,在选项表(QOption)中选出该题对应的选项,动态添加RadioButtonList项。
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
int qid=0;
RadioButtonList rb = new RadioButtonList();
if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
{
e.Item.Cells[4].Controls.Add(rb);//在DataGrid1的第五列即选项列动态生成RadioButtonList
qid=Convert.ToInt32(((Label)(e.Item.FindControl("QuestionIDItem"))).Text);//获取题号
}
string strConn=System.Configuration.ConfigurationSettings.AppSettings["database"];
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
//SqlCommand cm=new SqlCommand("select Heading,OptionText from QOption,Paper_Question,Question where PaperID="+Paperid.ToString()+" and Paper_Question.QuestionID=QOption.QuestionID and Paper_Question.QuestionID=Question.QuestionID and Question.QuestionType="+Typeid.ToString(),cn);
SqlCommand cm=new SqlCommand("select Heading,OptionText from QOption where QuestionID="+qid.ToString(),cn);
SqlDataReader dr=cm.ExecuteReader();
while(dr.Read())
{
rb.Items.Add(dr["Heading"].ToString()+"."+dr["OptionText"].ToString());//动态添加RadioButtonList成员即题目选项
}
cn.Close();
}
4.完成~