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);
}
