ASP.NET Core with ADO.NET | Dropdown lists for Create and Edit actions

Rajesh Thampi

Greeings

I am struggling with my 1st ASP.NET Core using ADO.NET (Cannot implement entity due to existing database design) & having a tough time understanding dropdown list binding with data from database. Almost all the examples are calling the llist population tied to Index action.

For my intended application, Index view will be a customer listing page, from which I need to "Edit" or "Delete" them. Once the Edit action chosen, I need to provide the user to change multiple customer details using dropdown lists, sometimes the proceeding dropdown referring the predessor. I've seen Microsoft documents recommending using asp-for and asp-items instead of HTML helpers & much of the examples I could see are using HTML helpers for dropdown lists.

I am using .Net Core 5.0 with Visual Studio 2019. If there are good samples, documents, kindly refer them to me. ??

2 Replies

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

Rajesh Thampi5y ago
@Rijwan Hello & Thanks for your answer. Well, as I mentioned, I am not planning to use HTML helpers with .NET Core application. Will be considering @Microsoft's recommendations to use asp-for and asp-items. I was scavenging through few samples already available here & believe I found one (Creating Simple Cascading DropDownList In ASP.NET Core MVC With New Tag Helpers (c-sharpcorner.com) that meets my requirements. My issue is once again with implementing Entity Framework.
Anyway, I think I will able to change the entity to ADO.Net and finally achieve the goal by following above example.

regards and thanks once again!
Rijwan Ansari5y ago
Hi

You can do in this way in edit form
@Html.DropDownListFor(Expression> expression, IEnumerable selectList, string optionLabel, object htmlAttributes);
example:
"form-group">
            @Html.LabelFor(model => model.Educations, htmlAttributes: new { @class = "control-label col-md-2" })
            "col-md-10">
                @Html.DropDownListFor(model => model.Educations, (IEnumerable)ViewBag.EducationOptions, new { htmlAttributes = new { @class = "form-control" } })