DropDownList and SqlDataReader

[TOm]

How do I bind a SqlDataReader to a dropdownlist box?

I know how to construct a SqlDataReader dr and get the
values. Buit how do I bind it to a DropDownList box in C#?

This does not work

cboUsers.DataSource = dr;
cboUsers.Items.Clear();
cboUsers.DataTextField = dr.GetValue(1).ToString();
cboUsers.DataValueField = dr.GetValue(0).ToString();
cboUsers.DataBind();

Please advise.

Thanks

Tom

[Ignacio Machin \( .NET/ C# MVP \)]

Hi TOm,

Try setting the DataTextField and the DateValueField properties of the
dropdownlist.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"TOm" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

How do I bind a SqlDataReader to a dropdownlist box?

I know how to construct a SqlDataReader dr and get the
values. Buit how do I bind it to a DropDownList box in C#?

This does not work

cboUsers.DataSource = dr;
cboUsers.Items.Clear();
cboUsers.DataTextField = dr.GetValue(1).ToString();
cboUsers.DataValueField = dr.GetValue(0).ToString();
cboUsers.DataBind();

Please advise.

Thanks

Tom

[Tom]

Yip! Setting the properties in the HTML workd but not in
the code behind. Thanks for that!

Now that I know how to add items to a dropdown, do you
what I'd need to do to set a specific item in the as the
default one selected?

Tom

-----Original Message-----
Hi TOm,

Try setting the DataTextField and the DateValueField properties of thedropdownlist.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"TOm" <an*******@discussions.microsoft.com> wrote in messagenews:08****************************@phx.gbl...

How do I bind a SqlDataReader to a dropdownlist box?

I know how to construct a SqlDataReader dr and get the
values. Buit how do I bind it to a DropDownList box in C#?
This does not work

cboUsers.DataSource = dr;
cboUsers.Items.Clear();
cboUsers.DataTextField = dr.GetValue(1).ToString();
cboUsers.DataValueField = dr.GetValue(0).ToString();
cboUsers.DataBind();

Please advise.

Thanks

Tom

.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi Tom,

Just set the desired SelectedIndex property in the control, now if you don't
know the index of the elem you need then you have to iterate on the
collection and set the correct index, see that you have a SelectedItem and
SelectedValue but they are read only.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Tom" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

Yip! Setting the properties in the HTML workd but not in
the code behind. Thanks for that!

Now that I know how to add items to a dropdown, do you
what I'd need to do to set a specific item in the as the
default one selected?

Tom

-----Original Message-----
Hi TOm,

Try setting the DataTextField and the DateValueField

properties of the

dropdownlist.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"TOm" <an*******@discussions.microsoft.com> wrote in

message

news:08****************************@phx.gbl...

How do I bind a SqlDataReader to a dropdownlist box?

I know how to construct a SqlDataReader dr and get the
values. Buit how do I bind it to a DropDownList box in C#?
This does not work

cboUsers.DataSource = dr;
cboUsers.Items.Clear();
cboUsers.DataTextField = dr.GetValue(1).ToString();
cboUsers.DataValueField = dr.GetValue(0).ToString();
cboUsers.DataBind();

Please advise.

Thanks

Tom

.

[kuvpatel]

Tom

This code will help you....

It gets a datareader then binds it to the dropdownlist using in quotes the

name of the columns for the datavaluefield and datatextfield.

Therefore you do not need to use

dr.GetValue(1).ToString();

instead use:

dr.DataValueField = "yourkeyfield - column name in the reader"

dr.DataTextField = "yourtextfield - column name in the reader"

Hope it helps

Kuv

------------

SqlConnection conn = new SqlConnection("database=northwind; server=(local);

user=sa; pwd=;");

conn.Open();

SqlDataReader dr;

SqlCommand cmd = new SqlCommand("Select * from

customers",conn);

dr = cmd.ExecuteReader();

dr1.DataSource = dr;

dr1.DataTextField = "contactname";

dr1.DataValueField = "customerid";

dr1.DataBind();

"TOm" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

How do I bind a SqlDataReader to a dropdownlist box?

I know how to construct a SqlDataReader dr and get the
values. Buit how do I bind it to a DropDownList box in C#?

This does not work

cboUsers.DataSource = dr;
cboUsers.Items.Clear();
cboUsers.DataTextField = dr.GetValue(1).ToString();
cboUsers.DataValueField = dr.GetValue(0).ToString();
cboUsers.DataBind();

Please advise.

Thanks

Tom

[Tom]

Kuv:

Many thanks

Tom

-----Original Message-----
Tom

This code will help you....

It gets a datareader then binds it to the dropdownlist using in quotes the
name of the columns for the datavaluefield and datatextfield.
Therefore you do not need to use

dr.GetValue(1).ToString();

instead use:

dr.DataValueField = "yourkeyfield - column name in the reader"
dr.DataTextField = "yourtextfield - column name in the reader"
Hope it helps

Kuv

------------

SqlConnection conn = new SqlConnection ("database=northwind; server=(local);
user=sa; pwd=;");

conn.Open();

SqlDataReader dr;

SqlCommand cmd = new SqlCommand("Select * from

customers",conn);

dr = cmd.ExecuteReader();

dr1.DataSource = dr;

dr1.DataTextField = "contactname";

dr1.DataValueField = "customerid";

dr1.DataBind();

"TOm" <an*******@discussions.microsoft.com> wrote in messagenews:08****************************@phx.gbl...

How do I bind a SqlDataReader to a dropdownlist box?

I know how to construct a SqlDataReader dr and get the
values. Buit how do I bind it to a DropDownList box in C#?
This does not work

cboUsers.DataSource = dr;
cboUsers.Items.Clear();
cboUsers.DataTextField = dr.GetValue(1).ToString();
cboUsers.DataValueField = dr.GetValue(0).ToString();
cboUsers.DataBind();

Please advise.

Thanks

Tom

.