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) { //奇怪,这个空方发必须还的留着,不然就会报错误 }
datagridviewcombobox 联动
最新推荐文章于 2023-10-18 11:33:48 发布