set DatagridviewComboBoxColumn selectedValue

Question

0.00/5 (No votes)

See more:

Hi All,

i have a problem SETTING the DatagridviewComboBoxColumn selectedValue.

I have a grid that has 2 DatagridviewComboBoxColum.

please see the code below.

C#

DataTable datatable = new DataTable(DataSourceTable);
                     datatable = oDbConnection.MYSQLExecuteNonQuery("SELECT  * FROM "+ DataSourceTable , datatable);
                     DataGridViewComboBoxColumn oCol = new DataGridViewComboBoxColumn();

                     oCol.Name = ColumnName;
                     oCol.HeaderText = HeaderText;
                     oCol.DisplayMember = DisplayMember;
                     oCol.ValueMember = ValueMember;
                     oCol.DataPropertyName = ValueMember;
                     oCol.DataSource = datatable;
                     DgView.Columns.Add(oCol);

where ValueMember = "ProjectID"
and DisplayMember = "ProjectDescrption"

i dont have probelem GETing the value of the DatagridviewComboBoxColum

the problem is when i set the DatagridviewComboBoxColum value when i load the data in the datagridview which has ComboBox from the database.

instead displaying of DISPLAYMEMBER data, the comboBox Displying VALUEMEMBER.

thanks.

Posted 21-May-12 22:26pm

jerome dela cruz

Updated 11-Jan-19 19:24pm

Add a Solution

3 solutions

Add a Solution

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

Wendelius · Answer 1 · 2012-05-22T10:00:00

If you mean the the combobox is showing the value member data (data from Id column) instead of data from ProjectDescription column, then use the debugger to check that your variables (DisplayMember and ValueMember) contain correct column names.

If you mean that the display member data isn't showing the data at all, check that the column name is spelled correctly. Should the

C#

DisplayMember = "ProjectDescrption"

be

C#

DisplayMember = "ProjectDescription"

jerome dela cruz · Answer 2 · 2012-05-22T15:04:00

Solution 2

Hi,

The spelling is correct. what i'm trying to figure is how to SET the SELECTEDVALUE of the DatagridViewComboBoxColumn.

as per MSDN, the DatagridViewComboBoxColumn has no property of SELECTEDVALUE but VALUE.

Posted 22-May-12 15:04pm

jerome dela cruz

Member 12604226 · Answer 3 · 2019-01-11T19:24:00

in grid view combobox cell property value act as both selected value and selected text.
if you want to set grid combo selected value it only accepts integer type. if assigned value is string it automatically sets selected text of the grid combo.

eg:

dgv_Sales.Rows[i].Cells["grid_cmbUnit"].Value = 1 // this line of code sets selectedvalue

dgv_Sales.Rows[i].Cells["grid_cmbUnit"].Value = "KG" //this line of code sets selectedtext

set DatagridviewComboBoxColumn selectedValue

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

set DatagridviewComboBoxColumn selectedValue

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us