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

Vithal Wadje

5y583k7100Article

ASP.NETDatabase Using ASP.NET C#fill dropdown listpopulate dropdownlist

7 Comments

Join the conversation! Your thoughts help the community grow.

Subhasis Tripathy6y ago
Can u help me i want only particular data with respect to their id , data to be fetch and rest all the data should be in dropdown
Nomfundo Cindi9y ago
Thank you it worked!
Vithal Wadje10y ago
Concatenate all column of table in single like select Id+ Name+ City+ Gender as AliasNameAsYouwant from YourTable
Aparna Shukla10y ago
How to get all 4 columns of a particular table in the DropDownList (ID,NAME,CITY AND GENDER)
veera muthu11y ago
How to select particular sql row using dropdownlist??
Vithal Wadje12y ago
select id ':' Name from employee
mohammad baig12y ago
how can i get the records of employee id and name side by side in dropdownlist for exampleemployee id is: " 101" employee name is: "xyz" then how can i show the records like " 101: xyz " and this records coming from sql database table .

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:

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:

Open Visual Studio from Start - - All programs -- Microsoft Visual Studio.
Then go to to "File" -> "New" -> "WebSite..." then select Visual C# -> Web application.
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:

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