DataTable.GetRows Method (DataValueCursor[])

DataTable GetRows Method ( DataValueCursor )

TIBCO Spotfire 6.0 API Reference

Enumerates all rows for the columns specified by the given valueCursors.

Namespace: Spotfire.Dxp.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 13.19.7018.3940 (13.19.7018.3940)

Syntax

C++

Copy to Clipboard Print

public IEnumerable<DataRow> GetRows(
	params DataValueCursor[] valueCursors
)

public IEnumerable<DataRow> GetRows(
	params DataValueCursor[] valueCursors
)

Parameters

valueCursors: Type: Spotfire.Dxp.Data DataValueCursor
Specifies what columns to include in the enumeration and are used to access the individual data values for each row.

Return Value

Type: IEnumerable DataRow
An enumeration of all rows.

Examples

Copy to Clipboard Print

DataTable table;
DataValueCursor<int> cursor1 = DataValueCursor.Create<int>(table.Columns["Column1"]);
DataValueCursor<double> cursor2 = DataValueCursor.CreateNumeric(table.Columns["Column2"]);
DataValueCursor<string> cursor3 = DataValueCursor.CreateFormatted(table.Columns["Column3"]);

foreach (DataRow row in table.GetRows(cursor1, cursor2, cursor3)) 
{
  int rowIndex = row.Index;
  int value1 = cursor1.CurrentValue;
  double value2 = cursor2.CurrentValue;
  string value3 = cursor3.CurrentValue;
  DoSomething(rowIndex, value1, value2, value3);
}

DataTable table;
DataValueCursor<int> cursor1 = DataValueCursor.Create<int>(table.Columns["Column1"]);
DataValueCursor<double> cursor2 = DataValueCursor.CreateNumeric(table.Columns["Column2"]);
DataValueCursor<string> cursor3 = DataValueCursor.CreateFormatted(table.Columns["Column3"]);

foreach (DataRow row in table.GetRows(cursor1, cursor2, cursor3)) 
{
  int rowIndex = row.Index;
  int value1 = cursor1.CurrentValue;
  double value2 = cursor2.CurrentValue;
  string value3 = cursor3.CurrentValue;
  DoSomething(rowIndex, value1, value2, value3);
}