Variables from DataSet 2

[khowell78737]

I have a dataset that is populating a combobox with the "DataSource", "ValueMember" and "DisplayMember" properties of the combo box.

I want to concancate (sp?) the values from two cells in a row to fill the "DisplayMember" property.

My code:
comboBox.DataSource = dataSet.Tables("tblCity")
comboBox.ValueMember = "fldCityID"
comboBox.DisplayMemeber = "fldCityName")

I want the "DisplayMember" property to have something like
"fldCityName, fldState"

How do I achieve this?

Thanks in advance!
Kevin

 

[MickTheBelgian]

You could create a view/query which concatenates(SP!) both.

 

[cjburkha]

I think

comboBox.DisplayMemeber = dataSet.Tables("tblCity").Rows(0).Item("fldCityID") + "," + dataSet.Tables("fldCityName").Rows(0).Item("fldState")

Should work pretty well

 

[JohnYingling]

It can't be done that way. The Displaymember value is a string that is the name of a property, not an expression that can be evaluated. You would need to create a cell that already has the concatenation.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)