Thanks in advance for your help.
I'm getting the following error:
private void PopulateAsposeGrid()
{
ArrayList al = this._alUserChoiceList;
ArrayList al2 = null;
DataView dv = null;
SC.Item oItem = null;
WebCells agridCells = null;
int m_iSheet = 0;
if ((al != null) && (al.Count > 0))
{
agridResults.WebWorksheets.Clear();
// for each segment selected go the the db and fetch
for (int i = 0; i < al.Count; i++)
{
al2 = new ArrayList();
oItem = new SC.Item();
oItem.Text = ((SC.Item)al[i]).Text;
oItem.ID = ((SC.Item)al[i]).ID;
al2.Add(oItem);
using (SD.Opportunity o = new SD.Opportunity())
{
o.GetOpportunityScores(_SubStudyID, _StudyTypeID, al2,
_FilterFlag, _FilterValue, _FilterValue2, _FilterValueString,
_ImportanceFilterClause, _SatisfactionFilterClause,
_OpportunityFilterClause, _RankFilterClause, _IncludeOpportunity,
_IncludeProcessStep, _IncludeThemes, _IncludeRank,
_SubStudyName, _Sort);
if (o.DataTable.Rows.Count > 0)
{
dv = new DataView(o.DataTable);
this.agridResults.WebWorksheets.ImportDataView(dv, null, null, oItem.Text, 0, 0);
agridCells = agridResults.WebWorksheets[m_iSheet].Cells;
//format cells, set row height, etc.
m_iSheet++;
}
}
}
}
}