Distinct in dropdown list in asp.net mvc 5

Question

How to remove duplicate records from dropdown list this is working fine for me but I am getting records more than two because I have same names in my database but I want to remove duplicate records.

public ActionResult Index()
{
    List<OrbatTable> CountryList = db.OrbatTables.ToList();
    ViewBag.CountryList = new SelectList(CountryList, "CityName", "CityName");
    return View();             
}

public JsonResult GetStateList(String CityName)
{
    db.Configuration.ProxyCreationEnabled = false;
    List<OrbatTable> StateList = db.OrbatTables.Where(x => x.CityName == CityName)
        .Distinct().ToList();
    return Json(StateList, JsonRequestBehavior.AllowGet);        
}

and this is my code for drop down list

@if (ViewBag.CountryList != null)
{
    @Html.DropDownListFor(model => model.CityName, ViewBag.CountryList as SelectList, 
        "--Select City", new { @class = "form-control" })            
}

thanks i have done by using this code in my Public ActionResult Index(){ List<OrbatTable> CountryList = db.OrbatTables.DistinctBy(x => x.CityName).ToList(); } — Do You Know
– Do You Know, Commented Apr 30, 2018 at 11:03

Nagashree Hs · Accepted Answer · 2018-04-30 09:28:48Z

1

GroupBy can used here.

List<OrbatTable> StateList = db.OrbatTables.GroupBy(x => x.CityName == CityName)
        .Select(x =>x.First()).ToList();

edited Apr 30, 2018 at 9:28

answered Apr 30, 2018 at 8:47

Nagashree Hs

8536 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

egnomerator · Accepted Answer · 2018-04-30 08:16:39Z

0

2 options come to mind if I understand what your goal is:

(each option is a suggested edit to the body of your GetStateList method)

To stick close to what you are currently doing, you could try a nifty DistinctBy approach
You could create an empty target list and then iterate over your source list adding each item to the target list only if it's not already in the target list

(I would have just commented, but my reputation is not high enough.)

edited Apr 30, 2018 at 8:16

answered Apr 30, 2018 at 8:10

egnomerator

1,15510 silver badges16 bronze badges

Collectives™ on Stack Overflow

Distinct in dropdown list in asp.net mvc 5

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related