HELP!! Binding two column values to ASP.NET drop down list

[richfield]

Hi,

I've got a drop down list getting its values from a column in a dataset e.g Name.

code:

<aspropDownList id="ddlNames" runat="server" DataField="Id" Rows="1" DataTextField="Name" DataValueField="Price">


I need to change the Data Text field to display both Name and age.

So the drop down list may display

John
Paul
Andy

Is there a way to bind only the text value to Name and age also from the same dataset so it displays say

John 16
Paul 12
Andy 5

but the value remains the same as before?

 

[jshurst]

I don't know about doing it from a dataset. I did this by concatinating a string in my SQL statement. This returned both values together. If you can't find another way then you could do it this way. I can post some code if you would like.

 

[Veep]

protected void LoadNames()
{
// Connection string stuff here
SqlConnection conn = new SqlConnection(yourConnectionString);
conn.Open();
string strSql="SELECT ID, Name, Age From yourTable";
SqlCommand cmd = new SqlCommand(strSql,conn);
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
   ListItem li = new ListItem();
   li.Value = reader["ID"].ToString();
   li.Text = reader["Name"].ToString() + " - " + reader["Age"].ToString();
   ddlNames.Items.Add(li);
}
}

Let me know if you have any questions.