Hello!

i'm populating my listbox with a "select" statement that retrieves me informaton to fill up multiple columns, but this information stays completely mixed in the listbox. i'm using this code:

While Not rs_nomes.EOF
    list_result.AddItem rs_nomes(0).Value, 0
    list_result.AddItem rs_nomes(1).Value, 1
    list_result.AddItem rs_nomes(2).Value, 2
    list_result.AddItem rs_nomes(3).Value, 3
    list_result.AddItem rs_nomes(4).Value, 4
    list_result.AddItem rs_nomes(5).Value, 5
    rs_nomes.MoveNext
 Wend
how can put the information by columns?
thanks

Hi there,

Not sure what you're asking here. Can you give more details?

Is this about classic ASP or about ASP.NET 2.0? If the latter, why are you using old skool recordset stuff like EOF and MoveNext?

Imar

i'm using vb6.
i want that each row inside the "while" be a column in my listbox. i'm using recordset because i'm just adding an adicional function to an old project..
thanks for the help

In that case, you better repost this question in a VB 6 forum located here: http://p2p.wrox.com/visual-basic-13

The forum you posted your question in is about Visual Studio 2005....

Imar

try separating the items with semicolons:
rst.fields(0) & ";" & rst.fields(1) & ";" & rst.fields(3)

vmz