query of dropdownlist

Indu Yadav

9y765.NET

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

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Indu Yadav9y ago
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 Palanivel9y ago
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 Yadav9y ago
[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 Palanivel9y ago
Hi Indu,

Can you share your updated controller code?
Indu Yadav9y ago
sir this code is not working .................when i edit ...........second dropdownlist does not seclecting any value.
Ramesh Palanivel9y ago
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 Yadav9y ago
yes sir..............
script which i have been used

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 Balakrishnan9y ago
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 Yadav9y ago
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 Palanivel9y ago
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?