Solved

Why is my listbox not filling?????

Posted on 2009-05-13
4
250 Views
Last Modified: 2012-08-14
I am missing something, just not sure what.
I am filling a listbox using a dataset.  There is 1 record in the table and when I do message boxes to show if there are any items in the listbox, it shows that there is the 1 item, but the item does not show in the list box.
What am I doing wrong???
Below I use messageboxes to check that there is an item.
Private Sub FillTaskList(Optional ByVal bStartUp As Boolean = False)
        Dim cT As New cTasks(ConnectionString)
 
        cT.FillList(Me.lstTasks)
        MessageBox.Show(Me.lstTasks.Items.Count)
        If bStartUp Then
            cT.SetupTaskLUGrid(Me.fpGrdTasks)
            MessageBox.Show(Me.lstTasks.Items.Count)
            Me.lstTasks.SelectedIndex = -1
            MessageBox.Show(Me.lstTasks.Items.Count)
        End If
    End Sub
 
I fill the list using
Private Function SQLCombo() As String
        Dim str As String
 
        str = "SELECT TaskID, " _
        & " TaskName " _
        & " FROM TasksLU " _
        & " ORDER BY TaskName"
 
        Return str
 
    End Function
 
 
 
 
    Public Sub FillList(ByVal cnt As ListBox)
        Dim ds As New DataSet
 
        If DatabaseToUse() = BizObjs.DBType.Access Then
            'Access Database
            Dim dc As New OleDb.OleDbConnection(ConnectionString)
            Dim da As New OleDb.OleDbDataAdapter(SQLCombo, dc)
 
            Try
 
                da.Fill(ds)
                dc.Close()
                cnt.DataSource = ds.Tables(0)
                cnt.DisplayMember = "TaskName"
                cnt.ValueMember = "TaskID"
 
            Catch ex As Exception
 
                MessageBox.Show(ex.Message)
                ''Throw ex
 
            Finally
                dc.Close()
                da.Dispose()
            End Try
        End If
 
    End Sub

Open in new window

0
Comment
Question by:Sheritlw
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
Deathrace earned 250 total points
ID: 24377378
0
 

Author Comment

by:Sheritlw
ID: 24377450
This is a windows form VB 2008 net app and the listbox does not have a databind property.
Thanks
0
 
LVL 11

Assisted Solution

by:srikanthreddyn143
srikanthreddyn143 earned 250 total points
ID: 24378054
Try

Public Sub FillList(ByRef cnt As ListBox)
0
 

Author Comment

by:Sheritlw
ID: 24378092
unfortunately that didn't work:-(
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question