/// <summary> /// Function to fill cmbGodown /// </summary> public void FillGodownCombo() { try { GodownSP spGodown = new GodownSP(); DataTable dtblGodown = new DataTable(); dtblGodown = spGodown.GodownViewAll(); cmbGodown.DataSource = dtblGodown; cmbGodown.ValueMember = "godownId"; cmbGodown.DisplayMember = "godownName"; } catch (Exception ex) { MessageBox.Show("R1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill cmbGodownSearch /// </summary> public void FillSearchCombo() { try { GodownSP spGodown = new GodownSP(); DataTable dtblGodown = new DataTable(); dtblGodown = spGodown.GodownViewAll(); cmbGodownSearch.DataSource = dtblGodown; DataRow dr = dtblGodown.NewRow(); dr[1] = "All"; dtblGodown.Rows.InsertAt(dr, 0); cmbGodownSearch.ValueMember = "godownId"; cmbGodownSearch.DisplayMember = "godownName"; } catch (Exception ex) { MessageBox.Show("R2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Godown Combobox /// </summary> public void GodownComboFill() { try { GodownSP spGodown = new GodownSP(); DataTable dtbl = new DataTable(); dtbl = spGodown.GodownViewAll(); DataRow drowSelect = dtbl.NewRow(); drowSelect[0] = 0; drowSelect[1] = "All"; dtbl.Rows.InsertAt(drowSelect, 0); cmbGodown.DataSource = dtbl; cmbGodown.DisplayMember = "godownName"; cmbGodown.ValueMember = "godownId"; } catch (Exception ex) { MessageBox.Show("PS:06" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }