Binding results of a sql query to listbox

Question

I am getting stuck on this problem. It seems simple but for some reason im having trouble.

Here is what I have of the following:

 Try
        cn = New OleDbConnection("Provider=microsoft.Jet.OLEDB.4.0;Data Source=G:\Sean\BMSBonder3_0.mdb;")
        cn.Open()
        str = "Select Distinct BonderIdentifier From [Session]"
        cmd = New OleDbCommand(str, cn)
        dr = cmd.ExecuteReader

        dr.Read()
        If dr.Item(0).ToString <> "" Then
            ListBox1.Items.Add(dr.Item(0))
        End If

        cn.Close()
    Catch ex As Exception
        MsgBox(ex.Message)
    End Try

This works to get only one of the values. Actually the last. how can i get all of them?

Sorry for the newb question. Searching didnt help too much.

SLaks · Accepted Answer · 2010-02-23 21:48:24Z

2

You need to use a While loop to repeatedly execute your code until dr.Read() returns False.
For example:

While dr.Read()
    If dr.Item(0).ToString <> "" Then
        ListBox1.Items.Add(dr.Item(0))
    End If
Wend

answered Feb 23, 2010 at 21:48

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Binding results of a sql query to listbox

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related