Help!! Show two columns in ComboBox.DisplayMember

It’s work. Those two columns have different datatype. Thank you very mach. I owing beer :)

I don't see any problem with your code. Check whether columns ProdName and kol are of same datatype? If not then you might need to cast them.

I instal Access 2003 but is the same. Like this program work ok. oleDbConnection1.Open(); OleDbDataAdapter DAProdukt = new OleDbDataAdapter("select ProduktID, ProdName FROM Producti",oleDbConnection1); DataSet DSProdukti = new DataSet(); DAProdukt.Fill(DSProdukti); comboBox1.DataSource = DSProdukti.Tables[0]; comboBox1.DisplayMember = "ProdName"; comboBox1.ValueMember = "ProduktID"; label1.Text = comboBox1.SelectedValue.ToString(); ---------------------------------------------------------------- But this not work ----------------- oleDbConnection1.Open(); OleDbDataAdapter DAProdukt = new OleDbDataAdapter("select ProduktID, ProdName +'-'+ kol AS ProdKol FROM Producti",oleDbConnection1); DataSet DSProdukti = new DataSet(); DAProdukt.Fill(DSProdukti); comboBox1.DataSource = DSProdukti.Tables[0]; comboBox1.DisplayMember = "ProdKol"; comboBox1.ValueMember = "ProduktID"; label1.Text = comboBox1.SelectedValue.ToString();

I tried with SQL and Access both and is working fine without any error. I'm using Access 2002. Can you post your query and your code where you are binding ComboBox1 to a datasource.

The database is in Access. Columns of table Table1 is : ID, FirstName, LastName I wont ComboBox1.DisplayMember to show - FirstName and LastName, and ComboBox1.ValueMamber - ID.

1. What database is it? 2. What exactly the names of the columns?

I try but it returns error. You can’t return concatenated string (Name + ' - ' + Address as NameAdd) from two columns.

Modify your query to return concatenated string. Hence your query would return something like this: select ID, Name + ' - ' + Address as NameAdd from Table1 In your code bind combobox1 like this way: ComboBox1.ValueMember = "ID"; ComboBox1.DisplayMember = "NameAdd"; Cheers, Yasser