Retrieve data from database using asp.net mvc and dropdownlist
Step a: Using Model (Purchase.dbml) class are ICustomerRepository and
Customer Repository.
Part1: How to create Linq to sql classess (Purchase.dbml)
Part2: How to create Repository Pattern in Model (ICustomerRepository and CustomerRepository)
Step b: Creating controller in Controller folder name is DropdownController
PurchaseDataContext db = new PurchaseDataContext();
public ActionResult Index()
{
ViewData["CustomerID"] = new SelectList
(
db.tblCustomers,
“CustomerID”,
“Name”
);
return View();
}
Step c: Go to View Folder in Solution Explorer ->Create new folder in view folder , folder name is dropdown -> right click on tblCustomers Add New Item -> choose view -> then Add view dialog box Popups
View Name (Index)
Choose Create a strongly-typed view -> In view data class dropdown
choose -> myFirstMVCapp.Models.tblCustomer
View content :In dropdown choose Empty
Write code as below in Index.aspx Page
<asp:Content ID=”Content2″
ContentPlaceHolderID=”MainContent” runat=”server”>
<h2>DropDown At runtime</h2>
<%= Html.DropDownList(”CustomerID”)%>
</asp:Content>
Link to dropdown/Index in view from Home/index page
Give in Home folder index.aspx page redirect ot dropdown/Index
<div>
<%= Html.ActionLink(”DropDownFill”, “Index”, “dropdown”) %>
</div>
mvc-dropdownlist
