Accessing values in combo box

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

I have a combo box that displays values from an SQL Server table.

It displays data from a number of columns.
When a value is chosen it displays only the first value in the combo box.

Is there any way to access the other values in the same row or do I have to
perform another select from the database.
The other possibillity would be to display a concatenation of strings in the
combo - but that would be a bit ugly.

Any ideas.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
You can use the "Column" property on the Combo-box/Listbox.

The "Column" property returns the data in String Data Type. It has the
following syntax:

object.Column(column,row)

object is the combo-box/listbox

column is the column number you want to retrieve, which the first column is
column number 0 while the nth column has the column number of n-1.

row is the row number you want to retrieve, which the first row is row
number 0 while the nth row has the row number of n-1.
 
Back
Top