public void LoadAtt_BY_EMPID_InListView(ListView lv) { Attendance a = new Attendance(); DataTable dt = new DataTable(); //get empid from combobox a.empid = Global.CURRENT_USER.empid; dt = a.SELECT_BY_EMPID(); if (dt != null) { lv.Items.Clear(); int ctr = 1; foreach (DataRow r in dt.Rows) { ListViewItem li = new ListViewItem(); li.Text = ctr.ToString(); li.SubItems.Add(Convert.ToDateTime(r["date_"].ToString()).ToShortDateString()); li.SubItems.Add(r["attendance"].ToString()); // li.SubItems.Add(Convert.ToDateTime(r["date_updated"].ToString()).ToLongDateString()); lv.Items.Add(li); ctr++; } } else { MessageBox.Show("Error"); } }
public void LoadAtt_BY_EMPID_InListView(ListView lv) { Attendance a = new Attendance(); DataTable dt = new DataTable(); //get empid from combobox String[] eid = cboEmp.Text.Split('-'); a.empid = eid[1]; dt = a.SELECT_BY_EMPID(); if (dt != null) { lv.Items.Clear(); 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["position_"].ToString()); li.SubItems.Add(Convert.ToDateTime(r["date_"].ToString()).ToShortDateString()); li.SubItems.Add(r["attendance"].ToString()); li.Tag = r["empid"].ToString(); // li.SubItems.Add(Convert.ToDateTime(r["date_updated"].ToString()).ToLongDateString()); lv.Items.Add(li); ctr++; } } else { MessageBox.Show("Error"); } }