c# - 选择后 DataGridViewComboBoxCell 显示 Value 成员而不是 Display 成员
问题描述
因此,我一直在研究 DataGridView,用户可以在其中更改一行中一个单元格的值,然后将同一行中另一个单元格的类型更改为 DataGridViewComboBoxCell 或返回 DataGridViewTextBoxCell。我可以让组合框像这样显示。
Dictionary<long, string> InspectionTools = new Dictionary<long, string>();
private void DynamicControlsDGV_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (DynamicControlsDGV.Columns[e.ColumnIndex].Name == "typeDataGridViewTextBoxColumn")
{
var type = int.Parse(DynamicControlsDGV[1, e.RowIndex].Value.ToString());
if (type == 8)
{
var CBCell = new DataGridViewComboBoxCell();
CBCell.DataSource = InspectionTools.ToList();
CBCell.ValueMember = "Key";
CBCell.DisplayMember = "Value";
CBCell.DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox;
DynamicControlsDGV[7, e.RowIndex] = CBCell;
}
else
{
var CBCell = new DataGridViewTextBoxCell();
DynamicControlsDGV[7, e.RowIndex] = CBCell;
}
}
}
但是,即使我在单击组合框单元格时看到所有值,但当我选择我想要的那个时,单元格会显示值成员(键/ID)而不是显示成员(值/名称)。如下所示:
有没有办法可以覆盖单元格格式,所以它不会将显示文本更改回 ID?
最小、完整和可验证的示例
制作 MCVE 后,我发现问题出在我的代码中的其他地方。这是我作为参考的 MSVE(效果很好):
代码背后:
public partial class Form1 : Form
{
public List<KeyValuePair<long, string>> options2 = new List<KeyValuePair<long, string>>();
public Form1()
{
InitializeComponent();
var options = new List<KeyValuePair<long, string>>();
options.Add(new KeyValuePair<long, string>(1, "text"));
options.Add(new KeyValuePair<long, string>(2, "combo"));
options2 = new List<KeyValuePair<long, string>>();
options2.Add(new KeyValuePair<long, string>(1, "option 1"));
options2.Add(new KeyValuePair<long, string>(2, "option 2"));
((DataGridViewComboBoxColumn)dataGridView1.Columns[0]).DataSource = options;
((DataGridViewComboBoxColumn)dataGridView1.Columns[0]).ValueMember = "Key";
((DataGridViewComboBoxColumn)dataGridView1.Columns[0]).DisplayMember = "Value";
for (int i = 0; i < 5; i++)
{
DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone();
dataGridView1.Rows.Add(row);
}
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex==0)
{
try
{
if (int.Parse(dataGridView1[e.ColumnIndex, e.RowIndex].Value.ToString()) == 2)
{
var CBCell = new DataGridViewComboBoxCell();
CBCell.DataSource = options2;
CBCell.ValueMember = "Key";
CBCell.DisplayMember = "Value";
CBCell.DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox;
dataGridView1[1, e.RowIndex] = CBCell;
}
else
{
var CBCell = new DataGridViewTextBoxCell();
dataGridView1[1, e.RowIndex] = CBCell;
}
}
catch
{
}
}
}
}
设计师:
partial class Form1
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.Column2 = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.SuspendLayout();
//
// dataGridView1
//
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.Column2,
this.Column3});
this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
this.dataGridView1.Location = new System.Drawing.Point(0, 0);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.Size = new System.Drawing.Size(879, 564);
this.dataGridView1.TabIndex = 0;
this.dataGridView1.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellValueChanged);
//
// Column2
//
this.Column2.HeaderText = "2";
this.Column2.Name = "Column2";
//
// Column3
//
this.Column3.HeaderText = "3";
this.Column3.Name = "Column3";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(879, 564);
this.Controls.Add(this.dataGridView1);
this.Name = "Form1";
this.Text = "Form1";
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.DataGridView dataGridView1;
private System.Windows.Forms.DataGridViewComboBoxColumn Column2;
private System.Windows.Forms.DataGridViewTextBoxColumn Column3;
}
另一个更新
我将 Dictionary 从 Dictionary 更改为 Dictionary ,因为我的原始示例是将 long 更改为字符串,因为它所基于的类将 string 作为 InstrumentName 的类型(我正在编辑的列)。因此,在单元格中设置的字符串值无法匹配它们在字典中的长键。
解决方案
数据网格视图基于通过 LINQ to SQL 创建的类。因此,列类型设置为字符串而不是默认的 Object。将组合框的数据源更改为字符串对后,字符串单元格的格式正确。
推荐阅读
- python - python中的这个斐波那契数列有什么错误?
- python - 在 django 中从 views.py 渲染特定的 div 标签
- postgresql - 模拟 AKS 中的应用程序和 Azure 中的 PostgreSQL 服务器之间的网络延迟
- java - 如何通过 Anylogic 中的基于代理的建模解决“java.lang.IndexOutOfBoundsException”问题?
- javascript - 删除功能删除所有内容而不是删除一项
- python - 正确答案后停止猜谜游戏
- amazon-dynamodb - 临时机包最佳实践
- javascript - 如何在 Kendo 中验证 dd/MM/yyyy 日期格式?
- java - 在位图上实现缩放和移动
- next.js - Apollo 没有在 ssr 中请求 graphql(通过 next.js)