private void LoadProjects() { SqlDataReader dr; ListViewItem lvi; this.Cursor = Cursors.WaitCursor; //SSS 20131105 dr = CBProject.GetList(); dr = CBProject.GetListProj(); lvwProjects.Items.Clear(); while (dr.Read()) { lvi = new ListViewItem(); lvi.Text = dr["ID"].ToString(); lvi.SubItems.Add(dr["Number"].ToString()); lvi.SubItems.Add(dr["Description"].ToString()); lvwProjects.Items.Add(lvi); } dr.Close(); dr = null; this.Cursor = Cursors.Default; }
private void LoadProjects() { SqlDataReader dr; RSLib.COListItem li; //SSS 20131105 dr = CBProject.GetList(); dr = CBProject.GetListProj(); clstProjects.Items.Clear(); li = new RSLib.COListItem(); li.ID = 0; li.Description = "All"; clstProjects.Items.Add(li); while (dr.Read()) { li = new RSLib.COListItem(); li.ID = Convert.ToInt32(dr["ID"]); li.Description = dr["Number"].ToString(); clstProjects.Items.Add(li); } clstProjects.SetItemChecked(0, true); dr.Close(); }
private void LoadItemList() { SqlDataReader dr; ListViewItem lvi; this.Cursor = Cursors.WaitCursor; //SSS 20131105 dr = CBProject.GetList(); dr = CBProject.GetListProj(); lvwItems.Items.Clear(); while (dr.Read()) { lvi = new ListViewItem(); lvi.Text = dr["ID"].ToString(); lvi.SubItems.Add(dr["Number"].ToString()); lvi.SubItems.Add(dr["Description"].ToString()); lvi.SubItems.Add(dr["Customer"].ToString()); lvi.SubItems.Add(dr["Location"].ToString()); lvwItems.Items.Add(lvi); } lvwItems.ColumnClick += new ColumnClickEventHandler(lvwItems_ColumnClick); dr.Close(); dr = null; sbPanStatus.Text = lvwItems.Items.Count.ToString() + " project(s)"; this.Cursor = Cursors.Default; }