How to bind database table into Dropdown(List) In ASP.net c#


In this article i will bind sql data table into Dropdown list using asp.net c#. i will use dataset and datatable to fetch the data from database and bind it into drop down list.


Step 1. Create a database name it Login.

Step 2. Create a table in Login database name it City_info.



Step 3. Insert Data into sql table (City_info).


insert into City_info values(1,'Delhi')
insert into City_info values(2,'Mumbai')
insert into City_info values(3,'Bangalore')
insert into City_info values(4,'Chennai')
insert into City_info values(5,'Pune')
insert into City_info values(1,'Lucknow')
insert into City_info values(2,'Jaipur')
insert into City_info values(3,'Ghāziābād')
insert into City_info values(4,'Indore')
insert into City_info values(5,'Vadodara')
insert into City_info values(1,'Ludhiāna')
insert into City_info values(2,'Āgra')
insert into City_info values(3,'Meerut')
insert into City_info values(4,'Bareilly')
insert into City_info values(5,'Raipur')


Step 4. Open visual studio and create a empty Web application name it Binddatagrid.



Step 5. Add a web form in the application (Binddatagrid) name it binddata.





Step 6. Add a Drop down List control on web form designer side or copy line given below.


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="binddata.aspx.cs" Inherits="binddata" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="ddlcity" runat="server"></asp:DropDownList>
    </div>
    </form>
</body>
</html>


Step 7. Add name space in code behind file.


using System.Data;
using System.Data.SqlClient;



Step 7. Add given Asp.net C# code on code behind file.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


using System.Data;
using System.Data.SqlClient;

public partial class binddata : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        DataTable dt = new DataTable();
        SqlConnection con= new SqlConnection(@"Server=.;Database=Login; Integrated Security=True;");  // connectio string for connect to database
        String patt = "select * from City_info ";
                SqlCommand cmd = new SqlCommand(patt, con); // sql command for command executaion 
                
                SqlDataAdapter da = new SqlDataAdapter(cmd); // dataadapter set of table
                dt = new DataTable();
                da.Fill(dt); // fill method use to fill data table from set of table 
                ddlcity.DataTextField = "City_name";
                ddlcity.DataValueField = "City_id";
                ddlcity.DataSource = dt;
                ddlcity.DataBind();

                ddlcity.Items.Insert(0, "--Select City--");
               
  
        }
    }

}

Result :  Run Application and result will be :