Saturday, March 22, 2014

MySQL VB.NET Tutorial 9 : How to Link Combobox with Database values





Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader
        Try
            MysqlConn.Open()
            Dim Query As String
            Query = "select *  from database.edata"
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader
            While READER.Read
                Dim sName = READER.GetString("name")
                ComboBox1.Items.Add(sName)

            End While
            MysqlConn.Close()
        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()
        End Try

    End Sub














--------------------------------------------------------

VB.Net: Filling a ComboBox with data stored in database

how to bind combobox to textbox in VB.NET

ComboBox and TextBox‎ VB.NET

How to show combo box selected value in a text box‎ VB.NET

selecting an item in combobox and display corresponding Populate combobox from  database VB.NET

How to get data in combobox from database?

Populating a Combobox from a Dictionary beginner

How to fill different ComboBoxes in a DataGridView  VB.NET

code add database column to datagridview combobox VB.NET

Populate combobox from database beginner

How to get data in combobox from database?

Populating a Combobox from a Dictionary Visual Basic

How to fill different ComboBoxes in a DataGridView

code add database column to datagridview combobox

Enter values into combobox from database‎ Visual Basic

Enter values into combobox from database‎ VB.NET

Retrive Data From Database Put Into A Combobox Visual Basic

Saving New Selection From Combobox To SQL Database

Set Datagridview Combobox Cell Value

Database Connections And Combo Boxes

No comments:

Post a Comment