private void LoadItemList() { SqlDataReader dr; ListViewItem lvi; this.Cursor = Cursors.WaitCursor; if (miDeptFilter != 0) { dr = CBEmployee.GetListByDept(miDeptFilter); } else { dr = CBEmployee.GetList(); } lvwItems.Items.Clear(); while (dr.Read()) { lvi = new ListViewItem(); lvi.Text = dr["ID"].ToString(); lvi.SubItems.Add(dr["Abbrev"].ToString()); lvi.SubItems.Add(dr["Name"].ToString()); lvwItems.Items.Add(lvi); } dr.Close(); dr = null; sbPanStatus.Text = lvwItems.Items.Count.ToString() + " employee(s)"; this.Cursor = Cursors.Default; }
private void LoadEmployeeBox() { SqlDataReader dr; RSLib.COListItem li; dr = CBEmployee.GetList(); cboEmployee.Items.Clear(); while (dr.Read()) { li = new RSLib.COListItem(); li.ID = Convert.ToInt32(dr["ID"]); li.Description = dr["Name"].ToString(); cboEmployee.Items.Add(li); } dr.Close(); }