How to Display related row records in DataGriedView to combobox by name value instead ID value

Question

0.00/5 (No votes)

See more:

I have this code to Fill data from datagriedview to combobox
but this code as you see give me the id's to combobox I wanna a way to show names in combobox using id's.
every combobox here is foreign key .
so I want when I move between records by click on DGV row display this record on comboboxes but with display names not values
How to Display the name by ID value when I load the data from datagriedview to combobox?

VB

Sub FILL_DATA_FROM_DGV()
       Dim pos As Integer = Me.DGView1.CurrentRow.Index
       Me.TB1.Text = DGView1.Rows(pos).Cells(0).Value
       Me.ComboBox1.Text = DGView1.Rows(pos).Cells(22).Value.ToString
       Me.ComboBox2.Text = DGView1.Rows(pos).Cells(20).Value.ToString
       Me.ComboBox3.Text = DGView1.Rows(pos).Cells(29).Value.ToString
       Me.ComboBox4.Text = DGView1.Rows(pos).Cells(14).Value.ToString
       Me.ComboBox5.Text = DGView1.Rows(pos).Cells(13).Value.ToString
       Me.ComboBox6.Text = DGView1.Rows(pos).Cells(9).Value.ToString
       Me.ComboBox7.Text = DGView1.Rows(pos).Cells(10).Value.ToString
       Me.ComboBox8.Text = DGView1.Rows(pos).Cells(26).Value.ToString
       Me.ComboBox9.Text = DGView1.Rows(pos).Cells(15).Value.ToString
       Me.ComboBox10.Text = DGView1.Rows(pos).Cells(18).Value.ToString
       Me.ComboBox11.Text = DGView1.Rows(pos).Cells(23).Value.ToString
 End sub

this image to explain more :

http://im55.gulfup.com/iuDiKt.png[^]

Posted 9-May-15 20:58pm

Muradooz

Updated 10-May-15 22:35pm

v5

Add a Solution

Comments

Michael_Davies 10-May-15 4:17am

Not sure what you are asking, the image seems to show what you expect. Can you clarify?

Muradooz 10-May-15 6:06am

yeah the image show what I except but I want to show names in combobox not the id value but I don't know How ?
for example I wanna show in color filed "RED" instead the ID "5".

Kornfeld Eliyahu Peter 10-May-15 7:42am

And your combo box contains an item that has the value of 5 and the text of RED?

Muradooz 11-May-15 2:59am

yes it is. ,every combobox is Foreign key here.

Maciej Los 10-May-15 8:57am

Does comboboxes are binded with datasource? How? Show your code...

Muradooz 11-May-15 3:09am

thanks @maciej Los for replay .
look I just load table to DGV in this table every combobox here is foreign key .
so I want when I move "click on row on DGV" between records display this record on comboboxes but with display names not values .
that's what I want exactly.

Muradooz 11-May-15 3:14am

this image for full screen
http://im55.gulfup.com/iuDiKt.png
sorry if I couldn't explain more .

Maciej Los 11-May-15 8:51am

Have you seen my answer?

2 solutions

Solution 1

First of all, you have to bind data to comboboxes to be able to get related values.

VB

With Me.ComboBoxColor
    .DataSource = DataTable1
    .DisplayMember = "ColorName"
    .ValueMember = "ColorId"
End With

'then
Me.ComboBoxColor.SelectedValue = 1
'combobox displays now related color, for example red

For further information, please see:
ComboBox.DataSource[^]
ComboBox.DisplayMember[^]
ComboBox.ValueMember[^]
ComboBox.SelectedValue[^]

Posted 10-May-15 6:07am

Maciej Los

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)

Muradooz · Accepted Answer · 2015-05-10T23:47:00

thanks every one for replay
I solved that
I hope that help any one search for solution for the same problem

VB

Sub FILL_DATA_FROM_DGV()
        Dim pos As Integer = Me.DGView1.CurrentRow.Index

        connection.Open()

 cmd = New SqlCommand("SELECT FIELD_NAME from TABLE_NAME WHERE  ID=@ITEMID", connection)
 cmd.Parameters.AddWithValue("@ITEMID",  DGView1.Rows(pos).Cells(22).Value.ToString)
       
        Dim dr As SqlDataReader = cmd.ExecuteReader
        If (dr.Read()) Then
            ComboBox1.Text = dr(0).ToString
        End If

        connection.Close()
End Sub 


 Private Sub DGView1_Click(sender As Object, e As EventArgs) Handles DGView1.Click

        Try
            FILL_DATA_FROM_DGV()
        Catch ex As Exception

        End Try


    End Sub