Click here to Skip to main content
15,899,026 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I have DataGridView with DataGridViewComboBoxColumn.
I have added Combo box and filled values in it from Database on DisplayMember as Description and Value Member as ID:

I have assigned below values to DataGridViewComboBoxColumn as Data Source in Data Table:

Description  | ID
-------------|---------
Test1           | 1
Test2           | 2`
Test3           | 3
Test4           | 4
-------------|---------

VB
dTable = Nothing
           Dim cComplexity As New DataGridViewComboBoxColumn
           dTable = FillCombo("SELECT_ON_CODE", "Complexity")
           cComplexity.DisplayMember = "Description"
           cComplexity.ValueMember = "ID"
           cComplexity.DataSource = dTable
           cComplexity.DataPropertyName = "Complexity"
           cComplexity.Name = "Complexity"
           cComplexity.HeaderText = "Complexity"
           cComplexity.DefaultCellStyle.NullValue = "Simple"
           cComplexity.FlatStyle = FlatStyle.Flat
           dtGrdImageDetails.Columns.Add(cComplexity)

           dTable = Nothing
           Dim cMultipart As New DataGridViewComboBoxColumn
           dTable = FillCombo("SELECT_ON_CODE", "Multipart")
           cMultipart.DisplayMember = "Description"
           cMultipart.ValueMember = "ID"
           cMultipart.DataSource = dTable
           cMultipart.DataPropertyName = "Multipart"
           cMultipart.Name = "Multipart"
           cMultipart.HeaderText = "Multipart"
           cMultipart.DefaultCellStyle.NullValue = "No"
           cMultipart.FlatStyle = FlatStyle.Flat
           dtGrdImageDetails.Columns.Add(cMultipart)


If Selected Value is Test3, I am getting Test3 but I want ValueMember value as 3.
Posted

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900