} //end Load Regular Members
public void LoadMembersInListView(ListView lv)
{
Member e = new Member();
DataTable dt = new DataTable();
dt = e.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["memid"].ToString());
li.SubItems.Add(r["fullname"].ToString());
li.SubItems.Add(r["address"].ToString());
li.SubItems.Add(r["contactno"].ToString());
Member_Standing ms = new Member_Standing();
ms.memid = r["memid"].ToString();
li.SubItems.Add(ms.STANDING);
li.SubItems.Add(r["tinno"].ToString());
li.BackColor = (ms.STANDING == "MIGS") ? Color.GreenYellow : Color.Red;
lv.Items.Add(li);
ctr++;
}
}
} //end LoadMembersInListView
public void LoadMembers(ComboBox cbo)
{
Member e = new Member();
DataTable dt = new DataTable();
dt = e.SELECT_ALL();
if (dt != null)
{
foreach (DataRow r in dt.Rows)
{
cbo.Items.Add(r["fullname"] + "-" + r["memid"]);
}
}
}
public void LoadMembersInListView(ListView lv)
{
Member e = new Member();
DataTable dt = new DataTable();
dt = e.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["memid"].ToString());
li.SubItems.Add(r["fullname"].ToString());
li.SubItems.Add(r["address"].ToString());
li.SubItems.Add(r["contactno"].ToString());
Member_Standing ms = new Member_Standing();
ms.memid = r["memid"].ToString();
li.SubItems.Add(ms.STANDING);
li.SubItems.Add(r["tinno"].ToString());
li.BackColor = (ms.STANDING == "MIGS") ? Color.GreenYellow : Color.Red;
lv.Items.Add(li);
ctr++;
}
}
}
public void LoadMembers(ComboBox cbo)
{
Member e = new Member();
DataTable dt = new DataTable();
dt = e.SELECT_ALL();
if (dt != null) {
foreach (DataRow r in dt.Rows) {
cbo.Items.Add(r["fullname"] + "-" + r["memid"]);
}
}
}