Hello-

I have a Listbox that I am attempting to fill from a database. I have set up my DataAdapter and Dataset to load the displaymember and valuemember for each row. The problem is, I want two values from my dataset to be displayed in seperate columns (or the same column...I don't care as long as they are both displayed). Can you please help? Thanks!

A listbox only has one displayed value. If you want more than 1 value, then you will have to modify your query to select more than one value into a single column result and then use that column as your display member.

Example:

SELECT UserName, LastName+', '+FirstName AS FullName FROM Users ORDER BY LastName, FirstName

Then you use "UserName" as your valuemember, and "FullName" as your displaymember.

Peter
------------------------------------------------------
Work smarter, not harder.

Note that the .NET listbox does support the UseTabStops property which allows you, after a fashion, to simulate multiple columns by inserting an appropriate number of tab characters in the strings you add to the listbox.

It's not very satisfying, but it does sort of work...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

I have come with this conclusion myself, However, is there a way to create a componant that can be writen to give an account of fields and columns?

Is there any expample code that can help aide in this delema.

thank you.

rb

I have found on C++ and you create an ActiveX Control, if you right click on the form, you can insert an ActiveX control called Microsoft Forms 2.0 Listbox. This can be found in the FM20.dll. When I inserted this object, I found that this is the component that we are looking for. However when I goto the VB environment, I find it under Microsoft Forms 2.0 Object Library. If you the goto Tools/Choose Toolbox item. When the window opens, you can scrool down and find the component. I added the component and could not find the the datasource and datafield properties. I also tried to compile and I got errors. I was also wanted to try to recreate this but an ActiveX designer included in the Enterprise Edition of Visual Basic, and I have the professional version.

This is my 2 cents.