How to load the values of list into listbox control

Question

1.20/5 (2 votes)

See more:

C#

Public Class customer
       Private name As String
       Private age As Integer
       Private Address As String
       Private salary As Double
       Public Sub New(ByVal cname As String, ByVal cage As Integer, ByVal caddress As String, ByVal sal As Double)
           name = cname
           age = cage
           Address = caddress
           salary = sal
       End Sub

   End Class

 Protected Sub btnFetch_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnFetch.Click
       
        Dim lst As New List(Of customer)
        Dim cmd As New SqlCommand("customerData", con)
        cmd.CommandType = CommandType.StoredProcedure
        cmd.Parameters.AddWithValue("@id", TextBox1.Text)
        Dim reader As SqlDataReader
        con.Open()
        Try
            reader = cmd.ExecuteReader()
        Catch ex As SqlClient.SqlException
            If InStr(ex.Message, "ID DOES NOT EXISTS", CompareMethod.Text) Then
                MsgBox("ID DOES NOT EXISTS")
            End If
        End Try
        While reader.Read
            lst.Add(New customer(reader("name"), reader("Age"), reader("Address"), reader("Salary")))
        End While
       //here i want to display the values from lst to listbox1
        ' ListBox1.DataSource = lst
        'For Each item As String In ListBox1.Items
        '    ListBox1.Items.Add(item)
        'Next
        con.Close()

Posted 29-Oct-14 1:11am

pulukuri aruna kumari

Updated 29-Oct-14 3:22am

SRS(The Coder)

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SRS(The Coder) · Accepted Answer · 2014-10-29T03:21:00

The ListBox will not bind data for all the columns it needs only two property values to set the DisplayText and the ValueField into the list box.

So let say, you are having Name and ID as those two values i am adding here an example for your help only :-

C#

ListBox1.DataSource = lst;
                ListBox1.DataTextField = "Name";
                ListBox1.DataValueField = "Id";
                ListBox1.DataBind();

NOTE : If you want multiple columns to be displayed then you can use GridView asp.net control for the purpose.

Hope this will definitely of help to you.