Listbox Loop

[OuTCasT]

I have bound a listbox with a dataTable

Now i want to move the values from the listbox to another listbox.
i have changed the selectionMode of the listbox to multiple.

So they choose multiple items and they get moved over to the other listbox.

for each item in listbox1.selecteditems
listbox2.items.add(item)
next

i get system.data.datarowview in the listbox2

how could i replace that with the actual value ?

[OuTCasT]

sqlCon.Open()
            sqlAdapter = New SqlDataAdapter(sqlCom)
            sqlTable = New DataTable
            sqlAdapter.Fill(sqlTable)
            Dim s As String
            For i = 0 To sqlTable.Rows.Count - 1
                s = sqlTable.Rows(i)("emailaddress").ToString
                ListBox1.Items.Add(s)
            Next
            sqlCon.Close()