DataTable.GetRows Method (IEnumerable(Int32), DataValueCursor[])

DataTable GetRows Method (IEnumerable Int32 , DataValueCursor )

TIBCO Spotfire 6.0 API Reference

Enumerates a subset of the rows for the columns specified by the given

valueCursors

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(
	IEnumerable<int> rowIndexes,
	params DataValueCursor[] valueCursors
)

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

Parameters

rowIndexes: Type: System.Collections.Generic IEnumerable Int32
The row indexes to enumerate.

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 emueration of the rows in the subset.

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"]);
DataSelection selection;

foreach (DataRow row in table.GetRows(selection, 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"]);
DataSelection selection;

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