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:
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:
No comments:
Post a Comment