📚 SAP Business One SDK Help

DataTable Object Members
See Also  Overview 

Public Methods

Public Method ClearClears all records from the data table.
Public Method CopyFromCopies the structure and data from the data table to another data table.
Public Method ExecuteQueryRuns the specified SQL query.
Public Method GetAsXMLReturns an XML string representation of the object.
Public Method GetSchemaReturns the schema for the XML that is returned by the SerializeAsXML method.
Public Method GetValueReturns the value of a cell in the data table.

The cell is specified by the combination of a column and row number. 

Public Method LoadFromXMLLoads the object from an XML string. 
Public Method LoadSerializedXMLLoads 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. 

Public Method SerializeAsXMLReturns information about the data table (the data and metadata) in XML format.

The schema of the XML is available using the GetSchema method.

Public Method SetValueSets the value of a cell in the data table.

The cell is specified by the combination of a column and row number.

Public Properties

Public Property ColumnsThe columns of the the data table.
Public Property IsEmptyIndicates whether the data table is empty or not.
Public Property RowsThe rows of the the data table.
Public Property UniqueIDThe unique ID of the data table.

See Also