Trying to get data from datagridview into combobox

Question

0.00/5 (No votes)

See more:

hey there.
im trying to get data from a table connected through access into my combobox. i'll key in the id first then click get then 5 values from that id will have to appear at the 5 combobox under. but my code seem not working. can anybody help me to show which part did i made wrong and its solution? thank you very much for ur help :D

VB

Public Sub Get_Data()
        con.Open()

        Dim dt As New DataTable("table1")
        Dim rs As New OleDb.OleDbDataAdapter("select * from table1 where id= '" & TextBox1.Text & "' ", con)
        rs.Fill(dt)

        DataGridView1.DataSource = dt
        DataGridView1.Refresh()

        rs.Dispose()
        con.Close()

        If Val(Label7.Text) = 1 Then
            Dim i As Integer
            i = DataGridView1.CurrentRow.Index

            ComboBox1.Text = DataGridView1.Item(1, i).Value.ToString()
            ComboBox2.Text = DataGridView1.Item(2, i).Value.ToString()
            ComboBox3.Text = DataGridView1.Item(3, i).Value.ToString()
            ComboBox4.Text = DataGridView1.Item(4, i).Value.ToString()
            ComboBox5.Text = DataGridView1.Item(5, i).Value.ToString()

        End If

    End Sub

VB

Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button4.Click
        Get_Data()

    End Sub

Posted 28-Jun-15 18:37pm

fahmijaafar

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ralf Meier · Accepted Answer · 2015-06-28T19:28:00

Solution 1

Use Combobox.Items.add intead of assigning it to .Text.

VB

ComboBox1.Items.clear
ComboBox1.Items.add( DataGridView1.Item(1, i).Value.ToString)
ComboBox1.Items.add( DataGridView1.Item(2, i).Value.ToString)
ComboBox1.Items.add( DataGridView1.Item(3, i).Value.ToString)
ComboBox1.Items.add( DataGridView1.Item(4, i).Value.ToString)
ComboBox1.Items.add( DataGridView1.Item(5, i).Value.ToString)

Posted 28-Jun-15 19:28pm

Ralf Meier

Comments

fahmijaafar 29-Jun-15 3:40am

ive tried the solution u provided but still the data doesn't appear on the combobox. :(

Ralf Meier 29-Jun-15 5:44am

If you set a Breakpoint into your Script/Method (GetData) - is there data displayed for the SelectedItem of the DGV ?

Ralf Meier 29-Jun-15 6:55am

Is "DataGridView1.Item(1, i).Value" the right access to the element you wish ? Perhaps you should use "DataGridView1.row(i).column(1).Value" ...

fahmijaafar 29-Jun-15 10:37am

luckily ive found the solution by just adding Me. infront of the combobox1. :D
btw thanks for ur help Mr. Ralf Meier.