First, create your information object. For example :
public class Person : DotNetNuke.Entities.Modules.IHydratable {
public int PersonID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
#region IHydratable Members
public void Fill(IDataReader dr) {
PersonID = Convert.ToInt32(dr["PersonID"]);
FirstName = dr["FirstName"].ToString();
LastName = dr["LastName"].ToString();
}
public int KeyID {
get {
return PersonID;
}
set {
PersonID=value;
}
}
#endregion
}
Then, you can using CBO class like below :
CBO.FillCollection<PersonInfo>(SqlHelper.ExecuteReader(ConnectionString, CommandType.StoredProcedure, "usp_YourSP", "params_if_any"));
It's much simpler and fast.
HTH.