How to bind the data to DropDownList from database in ASP.NET MVC 4 razor using C#

Hi Friends ,in this article I will explain about How to bind DropDownList from database in C# MVC 4 razor.
In previous artciles i already explained about How to Create Cascading DropDownList in MVC 4 Razor and JQuery,MVC4 Razor:How to call Stored Procedure using C# and MVC4 Razor :Routing or Set StartUp page in MVC4 with example

NEXT CHAPTER>>

In Dropdownlist controller:

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using MvcCRUD.Models; using System.Data; using System.Data.SqlClient; namespace MvcCRUD.Controllers {     public class DropDownListController : Controller     {         public ActionResult Bind()         {                      StudentContext db = new StudentContext();                                      List<string> x = new List<string>();             var firstname = from fname in db.students                        orderby fname.ID                        select fname.FIRSTNAME;             x.AddRange(firstname.Distinct());             ViewBag.firstname = new SelectList(x);             List<string> y = new List<string>();             var lastname = from lname in db.students                        orderby lname.ID                        select lname.LASTNAME;             y.AddRange(lastname.Distinct());              ViewBag.lastname = new SelectList(y);             return View();         }     } }

In bind.cshtml:

@{     ViewBag.Title = "Bind"; } <h2>Bind</h2> FirstName @Html.DropDownList("firstname") LastName @Html.DropDownList("lastname")

The output of the above code as shown in the below figure.

NEXT CHAPTER>>

"If you like my blog or articles, you can appreciate by leaving your comments or Liking my Facebook pageAspdotnet-kishore, following on Google+ Aspdotnet-Kishore, Twitter  on AspdotnetKishore, Linked in Aspdotnet-Kishore, stumbling my posts on stumble upon and subscribing on  RSSfeed Aspdotnet-Kishore for free updates directly to your Email inbox . Watch my blog  for more articles."