/// <summary> /// Function to fill additional cost /// </summary> public void AdditionalCostComboFill() { try { DataTable dtbl = new DataTable(); AccountLedgerSP spAccountLedger = new AccountLedgerSP(); dtbl = spAccountLedger.AdditionalCostGet(); dgvcmbAdditionalCostLedger.DataSource = dtbl; dgvcmbAdditionalCostLedger.ValueMember = "ledgerId"; dgvcmbAdditionalCostLedger.DisplayMember = "ledgerName"; } catch (Exception ex) { MessageBox.Show("SJ:25" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// dgvAdditionalCost grid cellbeginedit event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvAdditionalCost_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { try { DataTable dtbl = new DataTable(); AccountLedgerSP SpAccountLedger = new AccountLedgerSP(); if (dgvAdditionalCost.CurrentCell.ColumnIndex == dgvAdditionalCost.Columns["dgvcmbAdditionalCostLedger"].Index) { dtbl = SpAccountLedger.AdditionalCostGet(); if (dtbl.Rows.Count > 0) { if (dgvAdditionalCost.RowCount > 1) { int inGridRowCount = dgvAdditionalCost.RowCount; for (int inI = 0; inI < inGridRowCount - 1; inI++) { if (inI != e.RowIndex) { int inTableRowcount = dtbl.Rows.Count; for (int inJ = 0; inJ < inTableRowcount; inJ++) { if (dgvAdditionalCost.Rows[inI].Cells["dgvcmbAdditionalCostLedger"].Value != null && dgvAdditionalCost.Rows[inI].Cells["dgvcmbAdditionalCostLedger"].Value.ToString() != string.Empty) { if (dtbl.Rows[inJ]["ledgerId"].ToString() == dgvAdditionalCost.Rows[inI].Cells["dgvcmbAdditionalCostLedger"].Value.ToString()) { dtbl.Rows.RemoveAt(inJ); break; } } } } } } DataGridViewComboBoxCell dgvcmbLedger = (DataGridViewComboBoxCell)dgvAdditionalCost[dgvAdditionalCost.Columns["dgvcmbAdditionalCostLedger"].Index, e.RowIndex]; dgvcmbLedger.DataSource = dtbl; dgvcmbLedger.ValueMember = "ledgerId"; dgvcmbLedger.DisplayMember = "ledgerName"; } } } catch (Exception ex) { MessageBox.Show("SJ:77" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }