public void LoadEmployee(ComboBox cbo) { Employee e = new Employee(); DataTable dt = new DataTable(); dt = e.SELECT_ALL(); if (dt != null) { foreach (DataRow r in dt.Rows) { cbo.Items.Add(r["lname"] + ", " + r["fname"] + " " + r["mname"] + "-" + r["empid"]); } } }
public void LoadAllEployees() { Employee emp= new Employee(); DataTable dt = new DataTable(); dt = emp.SELECT_ALL(); if (dt != null) { int num=1; foreach(DataRow r in dt.Rows){ ListViewItem li = new ListViewItem(); li.Text = num.ToString(); li.SubItems.Add(r["empid"].ToString()); li.SubItems.Add(r["lname"].ToString() + ", " + r["fname"].ToString() + " " + r["mname"].ToString()); li.SubItems.Add(r["position_"].ToString());//r["position"].ToString()); li.SubItems.Add(r["contactno"].ToString()); //li.SubItems.Add(r["gender"].ToString()); li.SubItems.Add(r["address"].ToString()); lv.Items.Add(li); num++; } } }