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_classmodel.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].Textdata[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=0Text=Select} new SelectListItem{Value=1Text=MBA} new SelectListItem{Value=2Text=B.TECH} new SelectListItem{Value=3Text=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?