Skip to main content

ResultSet Class

NuGet: GHIElectronics.TinyCLR.Data.SQLite
Assembly: GHIElectronics.TinyCLR.Data.SQLite
Namespace: GHIElectronics.TinyCLR.Data.SQLite

Result of a SQL SELECT — rows × columns plus column-name metadata. Index by this[row] for an ArrayList of cells in that row, or this[row, column] for an individual cell.

public class ResultSet

Properties​

RowCount​

public int RowCount { get; }

The number of rows in the result set.

ColumnCount​

public int ColumnCount { get; }

The number of columns in the result set.

ColumnNames​

public string[] ColumnNames { get; }

The names of the columns in the result set.

Data​

public ArrayList Data { get; }

The rows of the result set, each an ArrayList of cell values.

row]​

public ArrayList this[int row] { get; }

Gets the cells of the given row as an ArrayList.

column]​

public object this[int row, int column] { get; }

Gets the value of the cell at the given row and column.