dropdownlist databind problems

[Srinivas]

Hi,

My function returns a datareader object containing only one column of
datatype money. In asp.net I want to bind this datareader to a dropdownlist.
Can anyone suggest me how to do this with some sample code if possible.

Thanks

Srinivas

[Gerald Klein]

I found it best to load them in functions such as below.

public static void Loadlist(DropDo wnList thisDropDownLis t , SqlDataReader
dr)
{
thisDropDownLis t.Items.Clear() ;
ListItem li;
while(dr.Read() )
{
li = new ListItem(dr[1].ToString().Tri m(),dr[0].ToString().Tri m());
thisDropDownLis t.Items.Add(li) ;
}
dr.Close();
}

"Srinivas" <an********@NO. JUNK.MAIL> wrote in message
news:e#******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

My function returns a datareader object containing only one column of
datatype money. In asp.net I want to bind this datareader to a dropdownlist. Can anyone suggest me how to do this with some sample code if possible.

Thanks

Srinivas

[Martha[MSFT]]

You can assign your reader to the DropDownList control's "DataSource "
property and call the DataBind() method. You must also set the
DropDownList's "DataTextFi eld" property to the column that you want to bind
to the control.
Here are some code pieces:

reader = command.Execute Reader();
ddList.DataSour ce = reader;
ddList.DataText Field = "money";
ddList.DataBind ();

<asp:DropDownLi st ID="ddList" Runat="Server">

Hope this helps,
Martha
"Srinivas" <an********@NO. JUNK.MAIL> wrote in message
news:e%******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

My function returns a datareader object containing only one column of
datatype money. In asp.net I want to bind this datareader to a dropdownlist. Can anyone suggest me how to do this with some sample code if possible.

Thanks

Srinivas

[Srinivas]

Thanks

I have tried the code. Its working fine. But the amounts are displayed as
100.000 as the datatype of the column from which the data is retrieved is
money. Is there any way to display the value 100.000 as 100

Srinivas
"Martha[MSFT]" <ma******@onlin e.microsoft.com > wrote in message
news:e5******** ******@TK2MSFTN GP11.phx.gbl...

You can assign your reader to the DropDownList control's "DataSource "
property and call the DataBind() method. You must also set the
DropDownList's "DataTextFi eld" property to the column that you want to bind to the control.
Here are some code pieces:

reader = command.Execute Reader();
ddList.DataSour ce = reader;
ddList.DataText Field = "money";
ddList.DataBind ();

<asp:DropDownLi st ID="ddList" Runat="Server">

Hope this helps,
Martha
"Srinivas" <an********@NO. JUNK.MAIL> wrote in message
news:e%******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

My function returns a datareader object containing only one column of
datatype money. In asp.net I want to bind this datareader to a

dropdownlist.

Can anyone suggest me how to do this with some sample code if possible.

Thanks

Srinivas