How to Bind Dropdownlist in using LINQ? - ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

How to Bind Dropdownlist in using LINQ?

Introduction: In this post I have try to explain how to bind/fill Dropdownlist control from database in LINQ.


I have create a table name OFFICE_DEPARTMENT

ID_DP is primary key of table.
Now go to Visual studio>File>New website> empty web site. Now go to Solution Explorer, right click on website>Add new item>Linq to Sql classes.

Now you see App_code folder will added to application and a dataclasses added with extension .dbml
in App_code folder.

Now check the web.config file of application. It self create a connectionstring for database.

Now connect the database to server explorer. After that drag and drop the table from database.

Add a web form to application. Go to Solution Explorer, right click on website>Add new item> Web from and drag and drop Dropdownlist from Toolbox.
<asp:DropDownList ID="ddlstate" runat="server">
Now got to .aspx.cs page and make an object of Dataclasses.
DataClassesDataContext db = new DataClassesDataContext();

protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)

public void Filldropdown()
            var statedrop = from c in db.OFFICE_DEPARTMENTs
                            select c;
            ddlstate.DataSource = statedrop;
            ddlstate.DataValueField = "ID_DP";
            ddlstate.DataTextField = "DEPARTMENT_NAME";
            ddlstate.Items.Insert(0, new ListItem("--Select--", "0"));
        catch (Exception EX)
Now debug the application and check the result

Related Articles on LINQ:

Ø  What is LINQ? Its advantage, disadvantage and types

Ø  How to Bind Gridview Data Control in LINQ?

Ø  How to insert data into database using Linq?

Is it helpful?

If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.