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) ?

<aspropDownList 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());
}