public List <DataTable> ModelNoViewAll() { List <DataTable> listObj = new List <DataTable>(); try { listObj = SpModelNo.ModelNoViewAll(); } catch (Exception ex) { MessageBox.Show("MN8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
/// <summary> /// Function to fill the ModelNo combobox /// </summary> public void ModelComboFill() { try { ModelNoSP spModelNo = new ModelNoSP(); DataTable dtblModelNo = new DataTable(); dtblModelNo = spModelNo.ModelNoViewAll(); DataRow dr = dtblModelNo.NewRow(); dr[1] = "All"; dtblModelNo.Rows.InsertAt(dr, 0); cmbModelNo.DataSource = dtblModelNo; cmbModelNo.ValueMember = "modelNoId"; cmbModelNo.DisplayMember = "modelNo"; } catch (Exception ex) { MessageBox.Show("PSP4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }