/// <summary> /// Function to fill the Area combobox /// </summary> public void AreaComboFill() { try { RouteSP spRoute = new RouteSP(); DataTable dtbl = new DataTable(); dtbl = spRoute.AreafillInRoute(); cmbArea.DataSource = dtbl; cmbArea.ValueMember = "areaId"; cmbArea.DisplayMember = "areaName"; cmbArea.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show("RT1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Area combobox fill for Search /// </summary> public void AreaComboFillSearch() { try { RouteSP spRoute = new RouteSP(); DataTable dtbl = new DataTable(); dtbl = spRoute.AreafillInRoute(); DataRow dr = dtbl.NewRow(); dr[1] = "All"; dtbl.Rows.InsertAt(dr, 0); cmbAreaSearch.DataSource = dtbl; cmbAreaSearch.ValueMember = "areaId"; cmbAreaSearch.DisplayMember = "areaName"; } catch (Exception ex) { MessageBox.Show("RT2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Area combobox fill for Search /// </summary> public void AreaComboFillSearch() { try { RouteSP spRoute = new RouteSP(); DataTable dtbl = new DataTable(); dtbl = spRoute.AreafillInRoute(); DataRow dr = dtbl.NewRow(); dr[1] = "All"; dtbl.Rows.InsertAt(dr, 0); cmbAreaSearch.DataSource = dtbl; cmbAreaSearch.ValueMember = "areaId"; cmbAreaSearch.DisplayMember = "areaName"; } catch (Exception ex) { MessageBox.Show("RT2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Area combobox fill for Search /// </summary> public void AreaComboFillSearch() { try { RouteSP spRoute = new RouteSP(); DataTable dtbl = new DataTable(); dtbl = spRoute.AreafillInRoute(); DataRow dr = dtbl.NewRow(); dr[1] = "All"; dtbl.Rows.InsertAt(dr, 0); cmbAreaSearch.DataSource = dtbl; cmbAreaSearch.ValueMember = "areaId"; cmbAreaSearch.DisplayMember = "areaName"; } catch (Exception ex) { formMDI.infoError.ErrorString = "RT2" + ex.Message; } }