Help!! Show two columns in ComboBox.DisplayMember

Question

I need to add in ComboBox1.DisplayMember values from two columns from one table. For example I have table Table1 with columns (ID Name Address). I wont ComboBox1.DisplayMember to show Name and Address and ComboBox1.ValueMamber ID. Thanks!!

tomekalaj · Answer

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

yasser_8227 · Answer

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.

tomekalaj · Answer

I instal Access 2003 but is the same. Like this program work ok. oleDbConnection1.Open(); OleDbDataAdapter DAProdukt = new OleDbDataAdapter(select ProduktID ProdName FROM ProductioleDbConnection1); 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 ProductioleDbConnection1); DataSet DSProdukti = new DataSet(); DAProdukt.Fill(DSProdukti); comboBox1.DataSource = DSProdukti.Tables[0]; comboBox1.DisplayMember = ProdKol; comboBox1.ValueMember = ProduktID; label1.Text = comboBox1.SelectedValue.ToString();

yasser_8227 · Answer

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.

tomekalaj · Answer

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.

miker · Answer

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

tomekalaj · Answer

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

yasser_8227 · Answer

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