コード例 #1
0
ファイル: Test.aspx.cs プロジェクト: Tomcooper12/QuizBuilder
        protected List<questions> GetQuestions(int id)
        {
            SQL sql = new SQL();
            DataTable DT = sql.getTestQuestions(id);
            List<questions> list = new List<questions>();
            foreach(DataRow dr in DT.Rows)
            {
                Objects.questions question = new Objects.questions();
                question.question = dr["question"].ToString().Replace("@!@", "<br>");
                question.qtype = int.Parse(dr["type"].ToString());
                question.question_id = int.Parse(dr["identity"].ToString());
                list.Add(question);
            }

            return list;
        }
コード例 #2
0
        protected void view_Click(object sender, EventArgs e)
        {
            questionsWrap.InnerHtml = "";
            try{
                int id = int.Parse(testDrop.SelectedItem.Value.ToString());
                SQL sql = new SQL();
                DataTable data = sql.getTestQuestions(id);

                if (data.Rows.Count > 0)
                {
                    foreach (DataRow r in data.Rows)
                    {
                        int qid = int.Parse(r["identity"].ToString());
                        string question = r["question"].ToString().Replace("@!@", "\n");
                        int type = int.Parse(r["type"].ToString());
                        switch (type) {
                            case 1:
                                StringBuilder sb = new StringBuilder();
                                sb.Append("<div class='row-fluid'><div class='well well-small'>");
                                sb.Append("<textarea disabled='disabled' qid='" + qid + "'>" + question + "</textarea><br />");
                                sb.Append("</div></div>");
                                questionsWrap.InnerHtml += sb.ToString();
                                break;
                            case 2:
                                StringBuilder sbtf = new StringBuilder();
                                sbtf.Append("<div class='row-fluid'><div class='well well-small'>");
                                sbtf.Append("<textarea disabled='disabled' qid='" + qid + "'>" + question + "</textarea>");
                                sbtf.Append("<select><option>True</option><option>False</option></select> <br />");
                                sbtf.Append("</div></div>");
                                questionsWrap.InnerHtml += sbtf.ToString();
                                break;
                        }
                    }
                }
                else
                {
                    error.Visible = true;
                }
            } catch(Exception){
                error.Visible = true;
            }
        }