VB.Net Populate ListBox With MySQL Data

How To Fill A ListBox From MySQL DataBase In VbNet

Fill ListBox From MySQL DataBase In VB.Net

In This VB.Net Tutorial  We Will See How To Add Data From MySQL DataBase Into A ListBox Using DataTable In Visual Basic.Net Programming Language And Visual Studio Editor.


Project Source Code:

Imports MySql.Data.MySqlClient

Public Class Populate_ListBox_From_MySQL

    Private Sub Populate_ListBox_From_MySQL_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        Dim connection As New MySqlConnection("datasource=localhost;port=3306;username=root;password=")
        Dim adapter As New MySqlDataAdapter("SELECT `Id`, `FullName`, `Address`, `BirthDate` FROM s_t_d.student", connection)
        Dim table As New DataTable()
        adapter.Fill(table)

        ListBox1.DataSource = table
        ListBox1.ValueMember = "Id"
        ListBox1.DisplayMember = "FullName"


    End Sub
End Class
      
///////////////OUTPUT:

VBNET ListBox With Data From MySQL




Share this

Related Posts

Previous
Next Post »