To navigate through records stored in a rowset

Report Application Server .NET SDK Developer Guide

To navigate through records stored in a rowset

Note

Use the isEOF method to check that you do not go out of bounds. If the TotalRecordKnown property is set to false, the getRecordCount method will not return accurate data.

Visual Basic

Private Function NavigateRowset(ByVal rcd As ISCDReportClientDocument, ByVal rowCursor As RowsetCursor) As String
 Dim rows As String = ""
 Do
  Dim currentRecord As Record = rowCursor.CurrentRecord
  rows += "<tr>"
  For i As Integer = 0 To currentRecord.Count - 1
   rows += "<td>" & currentRecord(i) & "</td>"
  Next
  rows += "</tr>"
  rowCursor.MoveNext()
 Loop While Not rowCursor.IsEOF
 Return rows
End Function

C#

private string NavigateRowset(ISCDReportClientDocument rcd, RowsetCursor rowCursor)
{
 String rows = "";
 do
 {
  Record currentRecord = rowCursor.CurrentRecord;
  rows += "<tr>";
  for (int i = 0; i < currentRecord.Count; i++)
  {
   rows += "<td>" + currentRecord[i] + "</td>";
  }
  rows += "</tr>";
  rowCursor.MoveNext();
 } while (!rowCursor.IsEOF);
 return rows;
}