/// <summary> /// Function to fill EmployeeCode Combobox /// </summary> public void EmployeeCodeComboFill() { try { EmployeeSP spEmployee = new EmployeeSP(); DataTable dtblEmployeeCode = new DataTable(); dtblEmployeeCode = spEmployee.EmployeeViewAll(); cmbEmployeeCode.DataSource = dtblEmployeeCode; cmbEmployeeCode.ValueMember = "employeeId"; cmbEmployeeCode.DisplayMember = "employeeCode"; } catch (Exception ex) { MessageBox.Show("BD1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill EmployeeCode combobox /// </summary> public void EmployeeCodeComboFill() { try { EmployeeSP spEmployee = new EmployeeSP(); DataTable dtblEmployee = spEmployee.EmployeeViewAll(); DataRow dr = dtblEmployee.NewRow(); dr[3] = "All"; dtblEmployee.Rows.InsertAt(dr, 0); cmbEmployeeCode.DataSource = dtblEmployee; cmbEmployeeCode.ValueMember = "employeeId"; cmbEmployeeCode.DisplayMember = "employeeCode"; } catch (Exception ex) { MessageBox.Show("MSR:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }