Category: Controls

Oct 29 2009

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

mvc-dropdownlist

Alibi3col theme by Themocracy