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
IT Certification Category (English)640x480

Partner Sites

VideoToGifs.com

EasyOnlineConverter.com

SqliteTutorials.com


Top Online Courses From ProgrammingKnowledge

Python Course http://bit.ly/2vsuMaS
Java Coursehttp://bit.ly/2GEfQMf
Bash Coursehttp://bit.ly/2DBVF0C
Linux Coursehttp://bit.ly/2IXuil0
C Course http://bit.ly/2GQCiD1
C++ Coursehttp://bit.ly/2V4oEVJ
PHP Coursehttp://bit.ly/2XP71WH
Android Coursehttp://bit.ly/2UHih5H
C# Coursehttp://bit.ly/2Vr7HEl
JavaFx Coursehttp://bit.ly/2XMvZWA
NodeJs Coursehttp://bit.ly/2GPg7gA
Jenkins Course http://bit.ly/2Wd4l4W
Scala Coursehttp://bit.ly/2PysyA4
Bootstrap Coursehttp://bit.ly/2DFQ2yC
MongoDB Coursehttp://bit.ly/2LaCJfP
QT C++ GUI Coursehttp://bit.ly/2vwqHSZ