public ActionResult List() { ListSurvey question = new ListSurvey(); question.questions = db.Questions.ToList(); question.surveys = db.Surveys.ToList(); return(View(question)); //return View(); }
public ActionResult List(string id) { string basequery = "Select * from questions"; List <Question> questions = db.Questions.SqlQuery(basequery).ToList(); string query = "Select * from surveys where questionid=@id"; SqlParameter parameter = new SqlParameter("@id", id); List <Survey> answers = db.Surveys.SqlQuery(query, parameter).ToList(); var ListSurvey = new ListSurvey(); ListSurvey.surveys = answers; ListSurvey.questions = questions; return(View(ListSurvey)); }