INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Adding items to Listbox from Database

Adding items to Listbox from Database

(OP)
I'm trying to loop through a select statement and put the results int oa listbox within a grid.

see below. I cannot get the listbox to populate.

Thanks in advance

Select Case e.Row.RowType
Case DataControlRowType.DataRow
myListBox.BackColor = Drawing.Color.Aqua

Dim sql As String = "select Records from Table WHERE week_number = '" & l1.Text & "'"
Dim connection As New SqlConnection(strcn1)

sCommand = New SqlCommand(sql, connection)
Dim dgDS As New DataSet


Dim dgDA As New SqlDataAdapter(sCommand)

dgDA.Fill(dgDS, "Table")

For Each r As DataRow In dgDS.Tables(0).Rows
myListBox.Items.Add(r("FieldName").ToString())
Next

myListBox.Items.Clear()
myListBox.DataSource = dgDS.Tables("Table")
myListBox.DataBind()

End Select

RE: Adding items to Listbox from Database

Why are you looping through the rows? Just bind to your dataset table.

CODE

myListBox.datasource = dgDS.tables(0)
myListBox.DataTextField = "yourcolumnname"
myListBox.DataValueField = "yourcolumnname"
mylistbox.databind() 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close