CanI (How do I) Make a DataList have multiple fields? 1

[THOMASNG]

Using VB6, I've successfully automatically populated my datalist control from an existing database.
However, this applies for only a single field. Ideally, I wish to simultaneously display three fields, to allow the user to make his selection more convenient.
Can I do this? If so, how?

 

[johnwm]

You may have chosen an inappropriate control for this purpose. If you can only use bound controls look into a Datagrid or Flexgrid. Otherwise you could use a Listview
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[sparky0904]

I think what u need to do is make the data appear in the select staement u use to retrieve the data.

i.e

SELECT Forename + ' ' + Surname + ' (' + Deptartment + ')' as Employee FROM EmployeeFile ORDER BY Employee

This would do someting like "Mark Taylor (IT)" by listing the EMployee as your Listfield.

Not sure on the SQL but that is the general idea i believe.

Mark Mark Taylor
Technical Manager
NHS

 

[THOMASNG]

Yes, DataGrid was pretty much pre-configured to do what I
needed.