Database values in textbox if select Combobox vb.net mysql

Question

i cant figure out my problem there is no error but value in combobox not showing from mysqldatabase here is my code

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

    Dim conn As New MySqlConnection

    conn.ConnectionString = "server=localhost;user vbid=root;password=admin;database=dnidb"

    Dim reader As MySqlDataReader

    Try
        conn.Open()
        Dim query As String
        query = "select * from dnidb.hargapro where NamaP = '" & ComboBox1.Text & "'"
        command = New MySqlCommand(query, conn)
        reader = command.ExecuteReader
        While reader.Read
            TextBox8.Text = reader.GetInt32("HargaP")
          End While
        conn.Close()
    Catch ex As Exception
        MessageBox.Show(ex.Message)
    Finally
        conn.Dispose()
    End Try


End Sub

this code was no error, but didnt show anything in the combobox, i try to make this cone on combobox_selectedindexchanges and same thing nothing showing up in the combobox

i just follow the code from here https://www.youtube.com/watch?v=HfnoGEmRGvc

I don't really understand your question, but I don't see any code that tries to add anything to a ComboBox. Can you clarify what you are trying to do and what is going wrong? — Blackwood
– Blackwood, Commented Aug 17, 2017 at 3:58
i want to list product name from my database into combobox and whenever i click one of the combobox item i want the price show on other textbox and the price from database to — Akira
– Akira, Commented Aug 17, 2017 at 4:26
I don't see any code to take product names from the database and put them in the ComboBox. — Blackwood
– Blackwood, Commented Aug 17, 2017 at 12:47

willa_012 · Accepted Answer · 2017-08-17 09:20:44Z

1

I don't see any code that tries to retrieve the product names to combobox, and it seems like the above code should be on SelectedIndexChanged event of the combobox.

answered Aug 17, 2017 at 9:20

willa_012

466 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database values in textbox if select Combobox vb.net mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related