public List <GetQuizList> GetQuestionAndAnswers(string Quiz) { List <GetQuizList> QuizList = new List <GetQuizList>(); string connString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlConnection con = new SqlConnection(connString); SqlCommand cmnd = new SqlCommand("GetAllQuestionsData", con); cmnd.CommandType = CommandType.StoredProcedure; SqlParameter ParamCheckname = new SqlParameter(); ParamCheckname.ParameterName = "@QuizName"; ParamCheckname.Value = Quiz; cmnd.Parameters.Add(ParamCheckname); con.Open(); SqlDataReader dr = cmnd.ExecuteReader(); while (dr.Read()) { GetQuizList ListOfQuiz = new GetQuizList(); ListOfQuiz.QuesID = dr["QuesID"].ToString(); ListOfQuiz.Question = dr["Question"].ToString(); ListOfQuiz.Answer1 = dr["Answer1"].ToString(); ListOfQuiz.Answer2 = dr["Answer2"].ToString(); ListOfQuiz.Answer3 = dr["Answer3"].ToString(); ListOfQuiz.Answer4 = dr["Answer4"].ToString(); ListOfQuiz.CorrectAnswer = dr["CorrectAnswer"].ToString(); ListOfQuiz.points = dr["points"].ToString(); QuizList.Add(ListOfQuiz); } return(QuizList); }
public List <GetQuizList> GetQuizList() { List <GetQuizList> QuizList = new List <GetQuizList>(); string connString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlConnection con = new SqlConnection(connString); SqlCommand cmnd = new SqlCommand("GetQuizNames", con); cmnd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader dr = cmnd.ExecuteReader(); while (dr.Read()) { GetQuizList ListOfQuiz = new GetQuizList(); ListOfQuiz.QuizList = dr["QuizName"].ToString(); QuizList.Add(ListOfQuiz); } return(QuizList); }