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 LoadAvailableEmployees() { SqlDataReader dr; RSLib.COListItem li; dr = CBEmployee.GetListByDept(miCurrDept); lstAvailable.Items.Clear(); while (dr.Read()) { li = new RSLib.COListItem(); li.ID = Convert.ToInt32(dr["ID"]); li.Description = dr["Name"].ToString(); lstAvailable.Items.Add(li); } dr.Close(); }
private void LoadLeads(int deptID) { SqlDataReader dr; RSLib.COListItem li; dr = CBEmployee.GetListByDept(deptID); clstProjects.Items.Clear(); while (dr.Read()) { li = new RSLib.COListItem(); li.ID = Convert.ToInt32(dr["ID"]); li.Description = dr["Name"].ToString(); clstProjects.Items.Add(li); } clstProjects.SetItemChecked(0, true); dr.Close(); }