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