public void LoadEmpSchedInListView(ListView lv) { Emp_Sched es = new Emp_Sched(); DataTable dt = new DataTable(); dt = es.SELECT_ALL(); if (dt != null) { int ctr = 1; foreach (DataRow r in dt.Rows) { ListViewItem li = new ListViewItem(); li.Text = ctr.ToString(); li.SubItems.Add(r["fullname"].ToString()); li.SubItems.Add(r["mon"].ToString()); li.SubItems.Add(r["tue"].ToString()); li.SubItems.Add(r["wed"].ToString()); li.SubItems.Add(r["thu"].ToString()); li.SubItems.Add(r["fri"].ToString()); li.SubItems.Add(r["sat"].ToString()); li.SubItems.Add(r["sun"].ToString()); li.SubItems.Add(Convert.ToDateTime(r["date_updated"].ToString()).ToShortDateString()); lv.Items.Add(li); ctr++; } } }
public void LoadEmpSched(ComboBox cbo) { Emp_Sched es = new Emp_Sched(); DataTable dt = new DataTable(); dt = es.SELECT_ALL(); if (dt != null) { foreach (DataRow r in dt.Rows) { cbo.Items.Add(r["lname"] + ", " + r["fname"] + " " + r["mname"] + "-" + r["empid"]); } } }