static void Main(string[] args) { DbQuiz dbq = new DbQuiz(); var newQuiz = new Quiz { Title = "En tomats farve" }; newQuiz.Answers.Add(new Answer { IsCorrectAnswer = false, Text = "Orange" }); newQuiz.Answers.Add(new Answer { IsCorrectAnswer = false, Text = "Blå" }); newQuiz.Answers.Add(new Answer { IsCorrectAnswer = true, Text = "Rød" }); DbQuiz.Create(newQuiz); }
public ArrayList getQuizById(string id) { ArrayList lst = new ArrayList(); using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("select * from cauHoi where mach = '" + id + "'", conn); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { DbQuiz obj = new DbQuiz(); obj.SanPham_IDataReader(dr); lst.Add(obj); } } } return(lst); }