How to retrieve data from dropdownlist in Asp.net ?

Question

5.00/5 (1 vote)

See more:

, +

Hi Experts !!

I have a dropdownlist in my aspx page.

I want to take the data from database and place in this dropdownlist. whatever the data is in table it must display in dropdown.

and when ever i add new item in table in should display in dropdownlist.

Please can you help me, how to do this.

Thanks.

Posted 23-Feb-13 20:07pm

Ranjith Reddy CSE

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Asim Mahmood · Answer 1 · 2013-02-23T20:17:00

C#

protected void Page_Load(object sender, EventArgs e)
        {
If(!IsPostBack)
  BindDropDownList();
}

private void BindDropDownList()
{
   DataTable dtData = new DataTable();
   dtData = //GetDataFromDb();
   this.Ddl.DataSource = dtData;
   this.Ddl.DataValueField = "ID";
   this.Ddl.DataTextField = "Name";
   this.Ddl.DataBind();
}

protected void BtnAdd_Click(object sender, EventArgs e)
{
    // Add data in DB
   BindDropDownList();
}

Please follow this link

http://stackoverflow.com/questions/4242766/binding-a-dropdownlist-to-a-database[^][]

Bassofa · Answer 2 · 2013-02-23T20:23:00

Several ways to do this:

you can write sql command that pull the data from the database as

SqlCommand cmd = new SqlCommand("Select Value1,Value2 from table");

And then specify the datasource of your dropdownlist as follows:
dropdownlist1.datasource() cmd.executereader();

dropdownlist1.datatextfield = "Value1" -- this means Value1 is what you want to show in the drop down

dropdownlist1.databind(); -- this what will do the final binding when you run the page.

There more resources and difference ways. Feel free to read more about different ways of doing things.

*Abhishek Pant* · Answer 3 · 2013-02-23T20:41:00

Solution 3

Binding DropDownList With Database in ASP.NET[^]
Ajax Cascading Dropdownlist Sample with database using asp.net [^]

google[^]

Posted 23-Feb-13 20:41pm

Abhishek Pant

3796068 · Answer 4 · 2013-02-23T22:22:00

XML

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Dropdownlist_Insertshow._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Text="Name" Width="100px"></asp:Label>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
        <asp:Button ID="btn_add" runat="server" Text="Add Name" onclick="btn_add_Click"
            Width="100px" /><br />
    <asp:DropDownList ID="DropDownList1" runat="server">
        </asp:DropDownList><br />

    </div>
    </form>
</body>
</html>

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Dropdownlist_Insertshow
{
public partial class _Default : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dropbind();
}
}

protected void btn_add_Click(object sender, EventArgs e)
{
DropDownList1.Items.Clear();
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "Insert into employee values('" + TextBox1.Text + "')";
com = new SqlCommand(str, con);
com.ExecuteNonQuery();
Response.Write("Records successfully inserted");
clear();
dropbind();
}
private void clear()
{
TextBox1.Text = "";
}
private void dropbind()
{

SqlConnection con = new SqlConnection(strConnString);
DropDownList1.Items.Add("Choose Name");
con.Open();
str = "select * from employee";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
DropDownList1.Items.Add(reader["name"].ToString());
}
reader.Close();
con.Close();
}

}
}

How to retrieve data from dropdownlist in Asp.net ?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0