Displaying Data in DropDownList

[nmretd]

Is it possible to show 2 appended values in one dropdown list.

EG, I Want to show Firsname Lastname in the dropdown list below, but looks like this is only limited to showing one field (Firstname) ?

<asp:DropDownList id="ddDept" runat="server" Rows="1"
DataTextField="FirstName" DataValueField="DepartmentID" />

[Memnoch1207]

you can do something like this (C#)

SqlConnection Conn = new SqlConnection(your connectionstring);
SqlCommand Comm = new SqlCommand(your query, Conn);
SqlDataReader reader;

try
{
Conn.Open();
reader = Comm.ExecuteReader();

while(reader.Read())
{
ComboBox1.Items.Add(reader["firstName"] + " " + reader["lastName"]);
}

reader.Close();
Conn.Close();
}
catch(Exception ex)
{
MessageBox.Show("Error: " + ex.Message.ToString());
}