Asp.net DropDownList that populates a key value pairs on one line

Thanks for your assistance.  This works perfectly in a comma separated list.  How would this be passed in the view?  The javascript will only pass a single question_id at a time in drop down list.

The dropdown will pass whatever is bound to the value field.  So if you have the questions bound to that column or a list of strings then you'd be fine.  Without understanding exactly what you're trying to accomplish it's hard to tell you what to do.

After I select an exam I would like all the matching questions on one line on a comma separated list?  

After I select the exam: 8188, 8189, 3916, 3917, 3918, 3919, 3920....... all on the same line

You gave me the above code, I apologize I don't know how to plug it in the achieve the desired result

  var question = string.Join(",", (from x in db.exams
                            join y in db.exam_question on x.exam_id equals y.exam_id
                            where x.exam_id == exam_id
                            select y.ToString()).ToList());

Select allOpen in new window

Not...



Javascript:

<script>
    $(document).ready(function () {
        $("#ExamID").change(function () {
            $.get('@Url.Action("Get", "user_exam")',
                { ID: $("#ExamID").val() }, function (data) {
                    $("#question_id").empty();
                    $.each(data, function (index, row) {
                        $("#question_id").append(" <option value='" + row.question_id + "'>" + row.question_id + "</option>")
                    });
                })
        });
    });
</script>

Select allOpen in new window

<option value='" + row.question_id + "'>"

you can update that to use the new questions.  Just adjust your viewbag to be the questions definition rather than question_id

Thanks for your assistance, I think I'm almost there.....

<script>
   $(document).ready(function () {
        $("#ExamID").change(function () {
            $.get('@Url.Action("Get", "user_exam")',
                { ID: $("#ExamID").val() }, function (data) {
                    $("#QuestionOrder").empty();   
                    //$.each( JSON.parse(data), function(index, row) {
                    //    $("#QuestionOrder").append(" <option value='" + row.question_id + "'>")
                    //})
                    $.each(data, function (index, row) {
                        $("#QuestionOrder").append(" <option value='" + row.question_id + "'>")
                    });                                                 
                })
        });
    });
</script>

Select allOpen in new window

When inspecting in the console I get the following error: Uncaught TypeError: Cannot use 'in' operator to search for '1033' in 8188,8189,8190,3916,3917,3918.......for the rest of the questions.  I tired to JSON.parse as well with no luck.


Controller

      public ActionResult NewExam(int? exam_id)
        {

            ViewBag.exam_id = new SelectList(db.exams.OrderBy(x => x.exam_desc), "exam_id", "exam_desc");



            var exam_question_order = string.Join(",", (from x in db.exams
                                             join y in db.exam_question on x.exam_id equals y.exam_id
                                             join z in db.questions on y.question_id equals z.question_id
                                             where x.exam_id == exam_id
                                             select z.question_id.ToString()).ToList());

            ViewBag.exam_question_order = new SelectList(from x in exam_question_order
                                                         select x).ToList();

            return View();
        }

        public JsonResult Get(int ID)
        {
            db.Configuration.ProxyCreationEnabled = false;
            var exam_question_order = string.Join(",", (from x in db.exams
                                                        join y in db.exam_question on x.exam_id equals y.exam_id
                                                        join z in db.questions on y.question_id equals z.question_id
                                                        where x.exam_id == ID
                                                        select z.question_id.ToString()).ToList());

            return Json(exam_question_order, JsonRequestBehavior.AllowGet);
        }

Select allOpen in new window

where x.exam_id == exam_id

since exam_id is int?  is x.Exam_ID the same type?  You may need exam_id.Value

exam_id and EXAM_ID are both the same type of int.  

<script>
    $(document).ready(function () {
        $("#ExamID").change(function () {
            $.get('@Url.Action("Get", "user_exam")',
                { exam_id: $("#ExamID").val() }, function (data) {
                    $("#question_id").empty();
                   // $.each(JSON.parse(data), function(index, row) {
                    //$.each($.parseJSON(data), function (index, row) {
                    $.each(data, function (index, row) {
                        $("#question_id").append(" <option value='" + row.question_id + "'>" + row.question_id + "</option>")
                    });
                })
        });
    });
</script>

Select allOpen in new window

When inspecting the gives me: Uncaught TypeError: Cannot use 'in' operator to search for '1033' in 8188,8189,8190,3916,3917,3918,3919,3920...the rest of the questions.   In the XHR I see the questions_id listed out 8188, 8189, 8190......

So I tried to use Json.parse and $.parseJSON and they both give me the same syntax error: Uncaught SyntaxError: Unexpected token , in JSON at position 4. In the XHR I see the questions_id listed out 8188, 8189, 8190......

use includes instead of in, but note that you have to wrap the string and the value in delimiters to prevent false positives.

eg:

question Ids:
1,11,111

Look for 1
Look for ",1,11,111,".includes(",1,");


More on includes here:
https://www.w3schools.com/jsref/jsref_includes.asp

Thanks for your assistance.  I'm still struggling to piece everything together.  I have been trying to search for anything that will give me an example of a comma separated list after selecting an item.   What would be an appropriate google search?