How to display names alphabetic order in dropdownlist

Seshu B

9y6.7kLearn iOS Programming

hi all,

i want to display names alphabetical order in dropdownlist from database using asp.net mvc5

this is my requiement
please give me soultion regarding this ...

4 Replies

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

Puneet Kankar9y ago

Accepted answer

try this code

Html.DropDownListFor(x => x.ID, new SelectList(Model.Fruit.OrderBy(y => y.Text), "Value", "Text"), "-- Select One --", new { @class = "form-control" })

https://stackoverflow.com/questions/1698266/how-to-sort-an-asp-net-mvc-dropdownlist

Seshu B9y ago
thanks Puneet kankar..
this code working fine
Rupesh Kahane9y ago
Refer my article

http://www.c-sharpcorner.com/article/dynamically-bind-the-dropdownlist-on-change-event-in-asp-net-mvc-5/

You have to use OrderBy clause as
DBContext objDBContext = new DBContext();
   List ItemDetail = new List();
            var sList = (from item in objDBContext.TableName
                              select new
                              {
                                  item.ID,
                                  item.Name
                              }).ToList();
            ItemDetail = sList.Select(s => new YourModel
            {
                ID = s.ID,
                Name = s.Name
            }).OrderBy(s => s.Name).ToList();
Ramesh Palanivel9y ago
Hi Seshu,

you can achieve this using order by keyword

If you have any doubt , pls share your controller code, i will help you