崔cccz 崔cccz
关注数: 4 粉丝数: 5 发帖数: 59 关注贴吧数: 24
“)”附近有语法错误 在线考试系统 考试读取试题 if (!IsPostBack) { string connStr = ConfigurationSettings.AppSettings["ConnectionString"].ToString(); string TitleID = ""; //int[] TitleID = { }; using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); for (int i = 0; i <TitleID.Length; i++) { SqlDataReader reader = null; cmd.CommandText = "select TitleID from PaperDetailmr where TitleID=@TitleID"; cmd.Parameters.Add(new SqlParameter("@TitleID", TitleID[i])); reader = cmd.ExecuteReader(); reader.Close(); } cmd.CommandText = "select Type from PaperDetailmr where paperID=1"; SqlDataReader sdr1 = cmd.ExecuteReader(); if (sdr1.Read()) { string type = sdr1["Type"].ToString(); sdr1.Close(); switch (type) { case "单选题": string str = "select * from SingleProblemmr where ID in (" + TitleID + ")"; SqlDataAdapter sda = new SqlDataAdapter(str,conn); DataSet ds = new DataSet(); sda.Fill(ds);//这出错,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, DataList1.DataSource = ds; DataList1.DataBind(); for (int i = 0; i < DataList1.Items.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; RadioButtonList rbtnl = (RadioButtonList)DataList1.Items[i].FindControl("rblTitle"); ListItem itemA = new ListItem(dr["AnswerA"].ToString()); ListItem itemB = new ListItem(dr["AnswerB"].ToString()); ListItem itemC = new ListItem(dr["AnswerC"].ToString()); ListItem itemD = new ListItem(dr["AnswerD"].ToString()); rbtnl.Items.Add(itemA); rbtnl.Items.Add(itemB); rbtnl.Items.Add(itemC); rbtnl.Items.Add(itemD); } break; case "多选题": string str1 = "select * from MultiProblemmr where ID in (" + TitleID + ")"; SqlDataAdapter sda1 = new SqlDataAdapter(str1, conn); DataSet ds1 = new DataSet(); sda1.Fill(ds1); DataList2.DataSource = ds1; DataList2.DataBind(); for (int i = 0; i < DataList2.Items.Count; i++) { DataRow dr = ds1.Tables[0].Rows[i]; CheckBoxList rbtnl = (CheckBoxList)DataList1.Items[i].FindControl("cblTitle"); ListItem itemA = new ListItem(dr["AnswerA"].ToString()); ListItem itemB = new ListItem(dr["AnswerB"].ToString()); ListItem itemC = new ListItem(dr["AnswerC"].ToString()); ListItem itemD = new ListItem(dr["AnswerD"].ToString()); rbtnl.Items.Add(itemA); rbtnl.Items.Add(itemB); rbtnl.Items.Add(itemC); rbtnl.Items.Add(itemD); } break; default: break; } } } }
1 下一页