public StatusCollection GetStatus()
{
StatusCollection status = new StatusCollection();
using (StatusDataAdapter adapter = new StatusDataAdapter())
{
IDataReader dr = adapter.GetStatus();
while (dr.Read())
{
status.Add(PopulateReader(dr));
}
dr.Dispose();
adapter.Dispose();
return status;
}
}
