Fill ASP.Net Dropdown List From Database Table Using ASP.NET C#

Background


Sometimes their is a need to fill a Drop Down List from a database table. For that many beginners get into trouble trying to fill the DropDownList from database table. so by considering above requirement i have written this article for beginners, students and anyone who wants to learn how to fill a DropDownList from a database table.

Now let us start by creating a table named employee in the database as in:

empdrop.png


I hope you have created the employee table in your database. Now insert records into the table as:

insert into  employee (FirstName) values ('vithal')
insert into  employee  (FirstName) values ('Sudhir')
insert into  employee  (FirstName) values ('virat')
insert into  employee  (FirstName) values ('Pravin')
insert into  employee  (FirstName) values ('Mayank')

Now let us start to create a Website as:
  1. Open Visual Studio from Start - - All programs -- Microsoft Visual Studio.
  2. Then go to to "File" -> "New" -> "WebSite..." then select Visual C# -> Web application.
  3. After that specify the name i.e Fill_dropdownlist or any name as you wish and the location of the project and click on the OK button. The new web site is created.
Use the following source code in the defualt.aspx <body> section page as:

<body bgcolor="#ccccff">
    <form id="form1" runat="server">
    <div class="div" align="center">
    <br /> <br />
        <asp:DropDownList ID="DropDownList1" runat="server" Width="100px">
        </asp:DropDownList>
    </div>
    </form>
</body>

Then switch to view code and use  the following code in the default.aspx.sc  page load as:
 
protected void Page_Load(object sender, EventArgs e)
    {

        string constr = ConfigurationManager.ConnectionStrings["binddropdown"].ToString(); // connection string
        SqlConnection con =new SqlConnection (constr);
        con.Open();

        SqlCommand com=new SqlCommand ("select *from employee",con); // table name 
        SqlDataAdapter da=new SqlDataAdapter(com);
        DataSet ds =new DataSet (); 
        da.Fill(ds);  // fill dataset
         DropDownList1.DataTextField = ds.Tables[0].Columns["FirstName"].ToString(); // text field name of table dispalyed in dropdown
        DropDownList1.DataValueField=ds.Tables[0].Columns["id"].ToString();             // to retrive specific  textfield name 
        DropDownList1.DataSource=ds.Tables[0];      //assigning datasource to the dropdownlist
        DropDownList1.DataBind();  //binding dropdownlist
    }

Now run the application and select a value from the DropDownList which looks as in the following image:

filldrodown.png


I hope this article is useful for all readers. If you have any suggestions then please contact me.

Note

  • Please download the zip file of source code
  • Make the changes in the web.config file according to your server location

Up Next
    Ebook Download
    View all
    Learn
    View all