how to write code to fetch data from database in dropdownlist

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

C#

ASP.NET

, +

How to write code to fetch data from database in dropdownlist. Textboxes are working fine.

C#

SqlCommand cmd = default(SqlCommand);
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
        con.Open();
        cmd = new SqlCommand("Select * from Call_Reg where Complaint_no='" + ddlupCompl.SelectedItem.ToString() + "'", con);
        SqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            txtFname.Text = Convert.ToString(reader["Cust_FName"]);
            txtLname.Text = Convert.ToString(reader["Cust_LName"]);
            txtPh.Text = Convert.ToString(reader["ph_no"]);
            txtMob.Text = Convert.ToString(reader["mob_no"]);
            txtemail.Text = Convert.ToString(reader["email"]);
            txtadd.Text = Convert.ToString(reader["address"]);
            txtcity.Text = Convert.ToString(reader["city"]);
            txtdist.Text = Convert.ToString(reader["dist"]);
            
        }
            con.Close();

Posted 3-Jan-13 0:47am

Member 9693583

Updated 3-Jan-13 0:50am

Herman<T>.Instance

v2

Add a Solution

Comments

Herman<T>.Instance 3-Jan-13 6:52am

just google: and find

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)

Zafar Sultan · Answer 1 · 2013-01-03T00:57:00

Suppose you have adropdownlist "drpCities" you want to show city list using this dropdownlist. Here is the sample code:

C#

SqlCommand cmd = default(SqlCommand);
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
con.Open();
cmd = new SqlCommand("Select cityId,cityName from City order by cityName", con);
cmd.CommandType = CommandType.Text;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
drpCities.DataSource = dt.DefaultView;
drpCities.DataTextField = "cityName";
drpCities.DataValueField = "cityId";
drpCities.DataBind();

Om Prakash Pant · Answer 2 · 2013-01-03T00:58:00

Solution 3

here is the simple example:

cmd.CommandText = "Select field1, field2 from yourTable";
cmd.Connection = conn;
conn.Open();
DataTable dt  = new DataTable();
dt.Load(cmd.ExecuteReader());
conn.Close();
DDownList1.DataSource = dt;
DDownList1.DataTextField = "field1";
DDownList1.DataValueField = "field2";
DDownList1.DataBind();

Posted 3-Jan-13 0:58am

Om Prakash Pant

Comments

Member 9693583 3-Jan-13 7:26am

I tried below code but there is no change in dropdownlist.... Dropdownlist is not showing the item.

SqlCommand cmd = default(SqlCommand);
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
con.Open();
cmd = new SqlCommand("Select * from Call_Reg where Complaint_no='" + ddlupCompl.SelectedItem.ToString() + "'", con);
SqlDataReader reader = cmd.ExecuteReader();
int i=0;
while (reader.Read())
{
txtFname.Text = Convert.ToString(reader["Cust_FName"]);
txtLname.Text = Convert.ToString(reader["Cust_LName"]);
txtPh.Text = Convert.ToString(reader["ph_no"]);
txtMob.Text = Convert.ToString(reader["mob_no"]);
txtemail.Text = Convert.ToString(reader["email"]);
txtadd.Text = Convert.ToString(reader["address"]);
txtcity.Text = Convert.ToString(reader["city"]);
txtdist.Text = Convert.ToString(reader["dist"]);
ddlstat.Items.Add(new ListItem(Convert.ToString(reader["state"]),i.ToString()));
i++;
}
con.Close();
}

$*Developer - Vaibhav*$ · Answer 3 · 2013-01-03T01:01:00

Solution 4

C#

cmd.CommandText = " Select * From GetUsersID";
cmd.Connection = conn;
conn.Open();
DataTable dt  = new DataTable();
dt.Load(cmd.ExecuteReader());
conn.Close();
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();

Posted 3-Jan-13 1:01am

$*Developer - Vaibhav*$

Updated 3-Jan-13 1:20am

v2

Comments

[no name] 3-Jan-13 7:22am

hi aarti,

what is wrong in solution 2 ?

Member 9693583 3-Jan-13 7:32am

Hi, Vaibhavmane, we have to insert list one by one or only one line code read all data for dropdownlist from database??? pls help.... thanks & regards,
kshitija

$*Developer - Vaibhav*$ 3-Jan-13 9:27am

Hi kshitija,
In your code senario first you bind the drop down on page load event

cmd.CommandText = " Select StateName, id_State From State";
cmd.Connection = conn;
conn.Open();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
conn.Close();
ddlstat.DataSource = dt;
ddlstat.DataTextField = "StateName";
ddlstat.DataValueField = "id_State";
ddlstat.DataBind();

then you write the below code to display the correct record.

ddlstat.SelectedIndex =
ddlstat.Items.IndexOf(ddlstat.Items.FindByValue(Convert.ToString(reader["state"])))

Aditya Magotra · Answer 4 · 2013-01-03T00:57:00

Solution 2

hi,

C#

int i = 0;
        while (reader.Read())
        {
            ddl.Items.Add(new ListItem(Convert.ToString(reader["Cust_FName"]), i.ToString()));
            i++;
        }

Posted 3-Jan-13 0:57am

Aditya Magotra

how to write code to fetch data from database in dropdownlist

4 solutions

Solution 1

Solution 3

Solution 4

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us