Display DB values in a dropdownlist

Question

I am displaying values from a database into a dropdownlist. but I am unable to get the corresponding values into the DDL.

if (dt.Rows.Count > 0)
            {
                DataTable dt1 = new DataTable();
                dt1 = bll.getnewid(TextBox1.Text);

                    if (dt1.Rows.Count > 0)
                    {

                        Session["pid"] = dt1.Rows[0]["NewidColumn"].ToString();
                        Session["email"] = dt1.Rows[0]["EmailID"].ToString();
                        Session["gender"] = dt1.Rows[0]["Gender"].ToString();
                        Session["mobile"] = dt1.Rows[0]["MobileNo"].ToString();
                        Session["country"] = dt1.Rows[0]["Country"].ToString();
                        Session["state"] = dt1.Rows[0]["State"].ToString();
                      }

and I am displaying like this

   DropDownList1.Text = Session["country"].ToString();
            DropDownList2.Text = Session["state"].ToString();

I am able to get the country and state values in the datatable. but I am unable to display them in the DDL.

Anant Dabhi · Accepted Answer · 2012-08-23 09:30:59Z

1

DropDownList1.Items.Add(new ListItem(Session["country"].ToString()); 
DropDownList2.Items.Add(new ListItem(Session["state"].ToString());
Dropdownlist2.databind();
Dropdownlist1.databind();

answered Aug 23, 2012 at 9:30

Anant Dabhi

11.2k3 gold badges33 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Chandra sekhar Over a year ago

When i do like this i am getting the values but in country ddl it is showing -select a country- instead the country name,how to display country name directly.

Anant Dabhi Over a year ago

DropDownList2.Items.Add(new ListItem(Session["ID"].ToString(),Session["countryname"].ToString());

Chandra sekhar Over a year ago

What is session["ID"] here?? I have not assigned anything to it probably Object reference not set to an instance of an object error will occur.

Anant Dabhi Over a year ago

it means you have to add counrty id to session ..before use

Anant Dabhi Over a year ago

Add this statement DropDownList2.SelectedIndex = 0;

|

walther · Accepted Answer · 2012-08-23 09:36:25Z

1

DropDownList1.Items.Add(new ListItem(Session["country"].ToString()); 
DropDownList2.Items.Add(new ListItem(Session["state"].ToString());

edited Aug 23, 2012 at 9:36

walther

13.6k5 gold badges44 silver badges67 bronze badges

answered Aug 23, 2012 at 9:13

Ashirvad

2,3771 gold badge16 silver badges20 bronze badges

1 Comment

Chandra sekhar Over a year ago

Argument '1': cannot convert from 'System.Web.UI.WebControls.ListItem' to 'System.Web.UI.Control' I am getting an error like this.

podiluska · Accepted Answer · 2012-08-23 09:13:33Z

0

You need to set the SelectedValue or SelectedIndex property of your dropdownlist.

answered Aug 23, 2012 at 9:13

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Comments

Satinder singh · Accepted Answer · 2012-08-23 09:31:07Z

0

try like this

   DropDownList1.Items.Add("yourvalue");
   DropDownList1.Items.Add(Session["country"].ToString());

answered Aug 23, 2012 at 9:31

Satinder singh

10.2k18 gold badges64 silver badges102 bronze badges

Comments

Krunal Mevada · Accepted Answer · 2012-08-23 09:34:30Z

0

Try This Code :

DropDownList1.Items.Insert(0, new ListItem(Session["country"].ToString(), "0"));
DropDownList1.DataBind();

DropDownList2.Items.Insert(0, new ListItem(Session["state"].ToString(), "0"));
DropDownList2.DataBind();

answered Aug 23, 2012 at 9:34

Krunal Mevada

1,6631 gold badge17 silver badges28 bronze badges

Comments

Sravan Kumar · Accepted Answer · 2012-08-23 09:35:04Z

0

What is the need of using sessions ..? Instead try this..hope it works. After this line of code (dt1 = bll.getnewid(TextBox1.Text);) use this two lines instead of sessions.

DropDownList1.DataSource=dt1;
DropDownList1.DataTextField="Country";
DropDownList1.DataValueField="Country";
DropDownList1.DataBind();
DropDownList2.DataSource=dt1;
DropDownList2.DataValueField="Country";
DropDownList2.DataValueField="Country";
DropDownList2.DataBind();

answered Aug 23, 2012 at 9:35

Sravan Kumar

1,4573 gold badges19 silver badges42 bronze badges

6 Comments

Sravan Kumar Over a year ago

here country and state are the names of the columns in the data table dt1. make sure column names match to the dt1.

Chandra sekhar Over a year ago

I am catching the country and state values and displaying in the another page so i am using session.

Sravan Kumar Over a year ago

do u mean to say the selected country and state or the entire list of countries and states..?

Chandra sekhar Over a year ago

I am populating the values from DB which are selected by the use and displaying them in the DDL not the list.

Sravan Kumar Over a year ago

From the code you have written you will get only the first row of the dt in sessions .Instead can't u store the dt in session and typecast it to datatable while accessing the values ?

|

Collectives™ on Stack Overflow

Display DB values in a dropdownlist

6 Answers 6

6 Comments

1 Comment

Comments

Comments

Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

6 Comments

1 Comment

Comments

Comments

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related