SAP Business One UI API 10.0 - Objects Reference (10.00.270)

• DataTable Object Members

  • UI API

  • • Public Methods

      Clear	Clears all records from the data table.
      CopyFrom	Copies the structure and data from the data table to another data table.
      ExecuteQuery	Runs the specified SQL query.
      GetAsXML	Returns an XML string representation of the object.
      GetSchema	Returns the schema for the XML that is returned by the SerializeAsXML method.
      GetValue	Returns the value of a cell in the data table. The cell is specified by the combination of a column and row number.
      LoadFromXML	Loads the object from an XML string.
      LoadSerializedXML	Loads data or metadata from an XML string. XML can be retrieved from a data table with the SerializeAsXML method, modified, and then reloaded using this method. The XML schema can be obtained from the GetSchema method.
      SerializeAsXML	Returns information about the data table (the data and metadata) in XML format. The schema of the XML is available using the GetSchema method.
      SetValue	Sets the value of a cell in the data table. The cell is specified by the combination of a column and row number.

  • • Public Properties

      Columns	The columns of the the data table.
      IsEmpty	Indicates whether the data table is empty or not.
      Rows	The rows of the the data table.
      UniqueID	The unique ID of the data table.

  • • See Also

      DataTable Overview