Skip to content

DataTable

Represents a table that contains data.

Capabilities

Row Management

Iteration and Access

  • DataTable.Each: Executes the given callback function for every row in the data table.
  • DataTable.Map: Converts all rows in the table to the return value of the given callback function.
  • DataTable.RowCount: Returns the number of rows in the data table.
  • DataTable.Rows: Returns all rows in the data table as a JavaScript array.

Conversion and Persistence

  • DataTable.ImportFromXml: Imports XML data into the specified table. If a record already exists in the table, it is updated. If no record exists, a new record is added to the table. Comparison is automatically done using the table's primary key.
  • DataTable.ToDictionary: Returns a DataTableDictionary indexed by the specified columns for fast access.

Mutation and Persistence

  • DataTable.Save: Saves changes made to the data table to the database.

Conversion