Populate ASP:dropdownlist using OutputParams

Hi Guys,

Anybody know how I can populate a dropdownlist using an output param from SQL?

I have:

...
SqlParameter parameterScores = new SqlParameter("@dotnet.itags.org.Scores", SqlDbType.NVarChar, 100);
parameterScores.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parameterScores);
...
...
Users userInfo = new Users();
userInfo.Name = (string)parameterName.Value;
userInfo.Scores = (string)parameterScores.Value;
return userInfo;
...
...
Name.Text = userInfo.Name;
scores.DataSource = userInfo.Scores;

Any help will be greatly apprecieated.

Thanksif 'Users' is a collection you should be able to use your code, be sure to call the scores.DataBind() method...

otherwise, just put the values in a collection (Dictionary, HashTable, etc) or array and access them.

// Method 1.) Binding...

Hashtable myHash = new Hashtable();
myHash.Add("key1", "Ohio"); // Add these when you get the info from the db
myHash.Add("key2", "Vermont"); // Add these when you get the info from the db

dd.DataSource = myHash;
dd.DataTextField = "Value";
dd.DataValueField = "Key";
dd.DataBind();

// Method 2.)

Just simply add the values when you've got them.

ie:

dd.Items.Add("Ohio"); // Add these when you get the info from the db
dd.Items.FindByText("Ohio").Value = "myKeyValue";

Let me know if you have problems...

populating asp:dropdownlist programmatically

I need to display a drop down list which holds up to 250 listitems.

I'd like to create this programmatically rather than have to hardcode it
into the page.

For example

<asp:DropDownList id="numYears" runat="server" name="numYears">
<asp:ListItem Value="0" Text="0 years" Selected="true" />
<asp:ListItem Value="1" Text="1 year"/>
<asp:ListItem Value="2" Text="2 year"/>
<asp:ListItem Value="2" Text="2 year"/>
<asp:ListItem Value="3" Text etc.......... up to 250 years

Thanks in advance..

Simon AmesHi,

put the DDL declaration at the Page (or create it in code just as you see
better).

<asp:DropDownList ID="ddl1" Runat="server">
</asp:DropDownList
Then say in Page_Load:

= = =
if(!Page.IsPostBack)
{
for(int i=0;i<251;i++)
{
ListItem litem=new ListItem(i.ToString() + " years",i.ToString());
ddl1.Items.Add(litem);
}
ddl1.SelectedIndex =0;
}
= = =

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist

"amessimon" <amessimon@.hotmail.com> wrote in message
news:e1ZyKV4AEHA.744@.TK2MSFTNGP10.phx.gbl...
I need to display a drop down list which holds up to 250 listitems.

I'd like to create this programmatically rather than have to hardcode it
into the page.

For example

<asp:DropDownList id="numYears" runat="server" name="numYears">
<asp:ListItem Value="0" Text="0 years" Selected="true" />
<asp:ListItem Value="1" Text="1 year"/>
<asp:ListItem Value="2" Text="2 year"/>
<asp:ListItem Value="2" Text="2 year"/>
<asp:ListItem Value="3" Text etc.......... up to 250 years

Thanks in advance..

Simon Ames
Hello Simon
"amessimon" <amessimon@.hotmail.com> schrieb im Newsbeitrag
news:e1ZyKV4AEHA.744@.TK2MSFTNGP10.phx.gbl...
> I need to display a drop down list which holds up to 250 listitems.
> I'd like to create this programmatically rather than have to hardcode it
> into the page.
> For example
> <asp:DropDownList id="numYears" runat="server" name="numYears">
> <asp:ListItem Value="0" Text="0 years" Selected="true" />
> <asp:ListItem Value="1" Text="1 year"/>
> <asp:ListItem Value="2" Text="2 year"/>
> <asp:ListItem Value="2" Text="2 year"/>
> <asp:ListItem Value="3" Text etc.......... up to 250 years

for (int i=0; i<=250; i++)

{

numYears.Items.Add(i.ToString());

}

mfg simon g.