datagridviewcombobox 联动

最新推荐文章于 2025-06-25 12:09:11 发布

原创最新推荐文章于 2025-06-25 12:09:11 发布 · 872 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#object #string

winform 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一个商品管理系统中如何实现数据绑定与实时更新的功能。通过使用数据集（bindingSource）和数据网格（dataGridView），系统能够动态加载并显示商品类型、品牌等信息，并在用户修改商品类型时自动更新相关品牌选项。该系统采用了分层数据绑定策略，确保了数据的一致性和高效性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

private void FrmSPXH_Load(object sender, EventArgs e) { this.dbchange = false; this.bindingSource1.DataSource = XTGL.GetTBL_SPXH(); this.bindingSource2.DataSource = XTGL.GetTBL_SPPP(); this.bindingSource3.DataSource = XTGL.GetTBL_SPLX(); //商品类型 DataGridViewComboBoxColumn dgvcboxLXMC = (DataGridViewComboBoxColumn)this.dataGridView1.Columns["LXMC"]; dgvcboxLXMC.DataSource = this.bindingSource3; dgvcboxLXMC.DisplayMember = "LXMC"; dgvcboxLXMC.ValueMember = "ID"; //商品品牌 DataGridViewComboBoxColumn dgvcboxPPMC = (DataGridViewComboBoxColumn)this.dataGridView1.Columns["PPMC"]; dgvcboxPPMC.DataSource = this.bindingSource2; dgvcboxPPMC.DisplayMember = "PPMC"; dgvcboxPPMC.ValueMember = "ID"; } private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Columns[e.ColumnIndex].Name == "LXMC") { DataGridViewCell cell = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]; DataGridViewComboBoxCell ppmc = (DataGridViewComboBoxCell)dataGridView1.Rows[e.RowIndex].Cells["PPMC"]; ppmc.DataSource = GetNewDV(cell.Value.ToString()); ppmc.DisplayMember = "PPMC"; ppmc.ValueMember = "ID"; } } private DataView GetNewDV(string value) { DataView dv = new DataView((DataTable)this.bindingSource2.DataSource); dv.RowFilter = "SPLXID = " + value; return dv; } private void dataGridView1_DataError(object sender, DataGridViewDataErrorEventArgs e) { //奇怪，这个空方发必须还的留着，不然就会报错误 }