private void filllvVolGroups()
{
for (int i = 0; i < clsVolGroups.NbrGroups; i++)
{
clsVolGroups.GroupIndex = i;
VolGroup volgrp = clsVolGroups.VolunGroup;
idxGroupId[i] = volgrp.GroupID;
ListViewItem lvItm = new ListViewItem();
lvItm.Group = lvVolGroups.Groups[constGroupName];
lvItm.Tag = volgrp.GroupID;
lvItm.SubItems.Add(volgrp.GroupName);
lvItm.SubItems.Add("0");
lvVolGroups.Items.Add(lvItm);
}
}
public VolGroups(string connStringIn)
{
int iNbrRows = 0;
conn = new SqlConnection();
conn.ConnectionString = connStringIn;
foreach (parmType item in CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_VolGroups))
{
VolGroup vgrp = new VolGroup(item.ID, item.TypeName);
VolGrps.Add(vgrp);
iNbrRows++;
}
//SqlCommand command = new SqlCommand("SELECT * FROM parm_VolunteerGroups ORDER BY [Type]", conn);
//SqlDataAdapter dadAdpt = new SqlDataAdapter();
//dadAdpt.SelectCommand = command;
//DataSet dset = new DataSet();
//iNbrRows = dadAdpt.Fill(dset);
//foreach (DataRow drow in dset.Tables[0].Rows)
//{
// VolGroup vgrp = new VolGroup(drow.Field<int>("Id"), drow.Field<string>("Type"));
// VolGrps.Add(vgrp);
//}
}
