Show two fields of a dataset in the same combobox c#

[omritt]

Hello, I'm trying to view filelds of a dataset in the same combobox:

This is how I get the first name only:
(I want to add "LastName" in to the combobox too to view the full name.)

comboBox2.DataSource = EmployeesDS.Tables["Employees"];
comboBox2.DisplayMember = "FirstName";

I'll appreciate any help,
(vs 2005 c#)
Thanks.

[chazcross]

In your select statement you can combine the first and last names columns into their own column which you can easily use.

or you can loop through your dataset and manually add the items to the list

foreach (DataRow row in EmployeesDS.Tables["Employees"].Rows)
{
            ListItem item = new ListItem();
            item.Text = row["lastName"].ToString() + ", " + row["firstName"].ToString();
            item.Value = row["colunmName"].ToString();
            comboBox2.Items.Add(item);
}

[omritt]

Thanks, I just changed the "ListItem" to simple "string" and it works now!
Thanks again, you saved my day!