in this code below im trying to read multiple columns and add to listboxbut its not workingPrivate Sub FillBehandelingens()
Try
Dim salon As String = HttpContext.Current.Session("salonName")
Dim SQLstring As String = "SELECT* from Behandelingen where SalonNaam='" + salon + "'"
Using connection As New OleDbConnection(con)
Using cmd As New OleDbCommand(SQLstring, connection)
cmd.CommandType = CommandType.Text
connection.Open()
Using reader As OleDbDataReader = cmd.ExecuteReader
While reader.Read
Dim item As ListItem = New ListItem
item.Text = reader.Item("Behandelingen") + "'" + ("prijs")
item.Value = reader.Item("ID")
...
Go to the complete details ...