VB.Net Display MySQL Data Depending On Combobox Value

How To Show Values From MySQL DataBase Based On ComboBox Value In VbNet

In This VB.Net Tutorial  We Will See How To Display Data From MySQL DataBase And Set Vaues Into TextBoxes And DateTimePicker According To ComboBox Selected Value Using   Visual Basic.Net Programming Language And Visual Studio Editor.

Project Source Code:

Imports MySql.Data.MySqlClient

Public Class Display_Data_From_MySQL_Depending_On_Combobox_Value

    Dim connection As New MySqlConnection("datasource=localhost;port=3306;username=root;password=")

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

        ' fill combobox from database using MySqlDataAdapter

        Dim adapter As New MySqlDataAdapter("SELECT `Id` FROM s_t_d.student", connection)

        Dim table As New DataTable()

        adapter.Fill(table)

        ComboBox1.DataSource = table

        ComboBox1.ValueMember = "Id"

        ComboBox1.DisplayMember = "Id"

    End Sub

    Private Sub ButtonShow_Click(sender As Object, e As EventArgs) Handles ButtonShow.Click

        Dim adapter2 As New MySqlDataAdapter("SELECT `Id`, `FullName`, `Address`, `BirthDate` FROM s_t_d.student WHERE id=" & ComboBox1.SelectedValue, connection)

        Dim table As New DataTable()

        adapter2.Fill(table)

        TextBox1.Text = table(0)(1)

        TextBox2.Text = table(0)(2)

        DateTimePicker1.Value = table(0)(3)

    End Sub

End Class

      

///////////////OUTPUT:

---

More VB.NET

➜ VB.Net Courses

➜ VB.Net Projects