在DataGridViewComboBoxColumn中设置selectedValue [英] Set selectedValue in DataGridViewComboBoxColumn

问题描述

我有两个表：列和表（外键 - Table_ID）。我想使用combobox在dataGridView中显示列。在要显示的组合框中，相关表（名称表）和所选项目是在列中设置的值。

I have two tables: columns and tables (foreign key - Table_ID). I want to show columns in dataGridView with combobox. In combobox to be displayed related table (name tables) and selected item be value that set in columns.

List<columns> columns = DataLoader.GetColumns();
List<tables> tables = DataLoader.GetTables();

this.editingDataGridView.DataSource = columns; // my dataGridView
DataGridViewComboBoxColumn comboBoxColumn = new DataGridViewComboBoxColumn();

comboBoxColumn.DisplayMember = "Table_Name";
comboBoxColumn.ValueMember = "Table_ID";
comboBoxColumn.DataSource = tables;

//add combobox column in dataGrid
this.editingDataGridView.Columns.Add(comboBoxColumn);

//AND this i want set value
int index = this.editingDataGridView.Columns.IndexOf(comboBoxColumn);
for (int i = 0; i < columns.Count; i++)
{
   this.editingDataGridView.Rows[i].Cells[index].Value = columns[i].Table_ID;
}

运行后，我得到gridView与combobox列与dataSource，值！

After run, I get gridView with combobox column with dataSource, but without selected default value!

推荐答案

关键点是

comboBoxColumn.DataPropertyName = "Table_ID";

需要设置dataGridComboBoxColumn的DataPropertyName

Need to set DataPropertyName of dataGridComboBoxColumn

更多此

这篇关于在DataGridViewComboBoxColumn中设置selectedValue的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！