query of dropdownlist

Question

how can i select text in dropdownlist while perform edit operation in mvc

Indu Yadav · Answer

In the place of that I am using this...................... ViewBag.gc = (from c in context.Applications where c.appearing_class == x.appearing_class select c).ToList(); here gc contains hardcoded list of second dropdownlist... public JsonResult GetClass(string id) { List gc = new List (); if (id != "0") { if (id == "1") { gc.Add(new SelectListItem { Text = " Appearing In Graduation", Value = "1" }); return Json(new SelectList(gc.ToArray(),"Value", "Text"), JsonRequestBehavior.AllowGet); } if (id == "2") { gc.Add(new SelectListItem { Text = "Appearing In Intermediate", Value = "2" }); return Json(new SelectList(gc.ToArray(), "Value", "Text"), JsonRequestBehavior.AllowGet); } if (id == "3") { gc.Add(new SelectListItem { Text = "Appearing In Highschool", Value = "3" }); return Json(new SelectList(gc.ToArray(), "Value", "Text"), JsonRequestBehavior.AllowGet); } } return Json(new SelectList(gc, "Value", "Text")); }

Ramesh Palanivel · Answer

Hi Indu, May I know what you are trying to get the value in this line.. I am not clear, Because in view you have hardcoded select list [HttpGet] public ActionResult EditData(int ? Candidate_Id) { Application model = context.Applications.Find(Candidate_Id); var x = (from c in context.Applications where c.Candidate_Id == Candidate_Id select c).FirstOrDefault(); model.Candidate_Id = x.Candidate_Id; model.Name = x.Name; model.Father_Name = x.Father_Name; model.Photograph = x.Photograph; model.Candidate_signature = x.Candidate_signature; model.Gender = x.Gender; model.DOB = x.DOB; model.course = x.course; model.appearing_class = x.appearing_class; ViewBag.gc = (from c in context.Applications where c.appearing_class == x.appearing_class select c).ToList(); // model.highschool = x.highschool; model.Passing_Year_10 = x.Passing_Year_10; model.Intermediate = x.Intermediate; model.Passing_Year_12 = x.Passing_Year_12; model.Graduation = x.Graduation; model.Contact_No1 = x.Contact_No1; model.Contact_No2 = x.Contact_No2; model.Email_Id = x.Email_Id; model.Residence = x.Residence; model.Exam_center_code = x.Exam_center_code; model.Category = x.Category; model.Occupation_father = x.Occupation_father; model.Income = x.Income; model.City = x.City; model.State = x.State; model.Mail_Id1 = x.Mail_Id1; model.Mail_Id2 = x.Mail_Id2; return View(model); }

Indu Yadav · Answer

[HttpGet] public ActionResult EditData(int ? Candidate_Id) { Application model = context.Applications.Find(Candidate_Id); var x = (from c in context.Applications where c.Candidate_Id == Candidate_Id select c).FirstOrDefault(); model.Candidate_Id = x.Candidate_Id; model.Name = x.Name; model.Father_Name = x.Father_Name; model.Photograph = x.Photograph; model.Candidate_signature = x.Candidate_signature; model.Gender = x.Gender; model.DOB = x.DOB; model.course = x.course; model.appearing_class = x.appearing_class; ViewBag.Candidate_Id = new SelectList(context.Applications.Where(c => c.appearing_class == "gc").ToList(), "appearing_class", "appearing_class",model.appearing_class.ToString()); // ViewBag.gc = (from c in context.Applications where c.appearing_class == x.appearing_class select c).ToList(); model.highschool = x.highschool; model.Passing_Year_10 = x.Passing_Year_10; model.Intermediate = x.Intermediate; model.Passing_Year_12 = x.Passing_Year_12; model.Graduation = x.Graduation; model.Contact_No1 = x.Contact_No1; model.Contact_No2 = x.Contact_No2; model.Email_Id = x.Email_Id; model.Residence = x.Residence; model.Exam_center_code = x.Exam_center_code; model.Category = x.Category; model.Occupation_father = x.Occupation_father; model.Income = x.Income; model.City = x.City; model.State = x.State; model.Mail_Id1 = x.Mail_Id1; model.Mail_Id2 = x.Mail_Id2; return View(model); }

Ramesh Palanivel · Answer

Hi Indu, Can you share your updated controller code?

Indu Yadav · Answer

sir this code is not working .................when i edit ...........second dropdownlist does not seclecting any value.

Ramesh Palanivel · Answer

Hi Indu, Yes I Understand, you can achieve this in two way, one is using jquery or you can bind it from controller, find the code for controller , public ActionResult Edit( int id) { OurDBContext db = new OurDBContext(); NewResourceRequest newresourcerequest = db.newresourcerequest.Single(x => x.resourcerequestid == id); //get the passed it details and binding it to model ViewBag.vendorid = new SelectList(db.lookup.Where(x => x.lookuptypename == "Vendor" ).ToList(), "lookupid" , "lookupname" , newresourcerequest.vendorid.ToString()); //db.lookup.Where(x => x.lookuptypename == "Vendor").ToList() binding the list from table whichever value has vendor //lookupid set the id of dropdownlist whichmean value //lookupname set the text of dropdownlist //newresourcerequest.vendorid.ToString() default selected value return View(newresourcerequest); } Using Jquery, $('#DropDownlistid').val($('#vendorid').val()) // write this code in inside document.ready function Note : store the vendorid value in hidden input field

Indu Yadav · Answer

yes sir.............. script which i have been used function SelectedIndexChanged() { $("#appearing_class").empty(); $.ajax({ type: 'POST', url: '@Url.Action("GetClass")', dataType: 'json', data: { Candidate_Id: $("#course").val() }, success: function (data) { $("#appearing_class").append(' Select '); for (var i = 0; i { var opt = new Option(data[i].Text,data[i].Value); $('#appearing_class').append(opt); } }, error: function (ex) { alert('Failed to retrieve values.' + ex); } }); } First dropdownlist................. Select Course @Html.DropDownListFor(model => model.course, new List { new SelectListItem{Value="0",Text="Select"}, new SelectListItem{Value="1",Text="MBA"}, new SelectListItem{Value="2",Text="B.TECH"}, new SelectListItem{Value="3",Text="POLYTECHNIC"} }, new { @class = "span6", @onchange = "SelectedIndexChanged()" }) Second Dropdownlist.......... IF You Are Appearing Condidate @if (ViewBag.gc != null) { @Html.DropDownListFor(model => model.appearing_class, new SelectList(ViewBag.gc as System.Collections.IEnumerable, "appearing_class", "appearing_class"),"Select") } controller code: public JsonResult GetClass(string Candidate_Id) { List gc = new List (); if (Candidate_Id != "0") { if (Candidate_Id == "1") { gc.Add(new SelectListItem { Text = " Appearing In Graduation", Value = "1" }); return Json(new SelectList(gc.ToArray(), "Value", "Text"), JsonRequestBehavior.AllowGet); } if (Candidate_Id == "2") { gc.Add(new SelectListItem { Text = "Appearing In Intermediate", Value = "2" }); return Json(new SelectList(gc.ToArray(), "Value", "Text"), JsonRequestBehavior.AllowGet); } if (Candidate_Id == "3") { gc.Add(new SelectListItem { Text = "Appearing In Highschool", Value = "3" }); return Json(new SelectList(gc.ToArray(), "Value", "Text"), JsonRequestBehavior.AllowGet); } } return Json(new SelectList(gc, "Value", "Text")); } Edit Action : [HttpGet] public ActionResult EditData(int ? Candidate_Id) { Application model = context.Applications.Find(Candidate_Id); var x = (from c in context.Applications where c.Candidate_Id == Candidate_Id select c).FirstOrDefault(); model.Candidate_Id = x.Candidate_Id; model.Name = x.Name; model.Father_Name = x.Father_Name; model.Photograph = x.Photograph; model.Candidate_signature = x.Candidate_signature; model.Gender = x.Gender; model.DOB = x.DOB; model.course = x.course; ViewBag.gc = (from c in context.Applications where c.appearing_class == x.appearing_class select c).ToList(); model.appearing_class = x.appearing_class; model.highschool = x.highschool; model.Passing_Year_10 = x.Passing_Year_10; model.Intermediate = x.Intermediate; model.Passing_Year_12 = x.Passing_Year_12; model.Graduation = x.Graduation; model.Contact_No1 = x.Contact_No1; model.Contact_No2 = x.Contact_No2; model.Email_Id = x.Email_Id; model.Residence = x.Residence; model.Exam_center_code = x.Exam_center_code; model.Category = x.Category; model.Occupation_father = x.Occupation_father; model.Income = x.Income; model.City = x.City; model.State = x.State; model.Mail_Id1 = x.Mail_Id1; model.Mail_Id2 = x.Mail_Id2; return View(model); }

Prasath Balakrishnan · Answer

Hi Indu, Can you share your piece of code here for our understanding , because cannot get your question exactly what you are trying to convey!.. Since, my understanding is you want to select the saved record from database. now you can able to see your id(value) only not as text. Am i correct?

Indu Yadav · Answer

yes sir ................you are right ...........i have done that work but the selected item is value for eg .....1, but i want text of that item like india.

Ramesh Palanivel · Answer

Hi Indu, while editing drop downlist , you want to be selected inserted record while coming in editing mode? This is my understanding? am I correct?

query of dropdownlist

Answers (10)