📚 SAP Business One SDK Help

DataTable Object
See Also  Members  Example

Description

Represents data in matrix form, for Matrix and Grid objects.

Object Model



Remarks

We recommend using this object instead of UserDataSource and DBDataSource for simplicity and better performance.

You can work efficiently with DataTable data using the GetSchema, SerializeAsXML, and LoadSerializedXML methods, as you would for matrix data, as described in Working with Matrix Data.

Example

Filling DataTable by query (Visual Basic)Copy Code
Set oDataTable = oForm.DataSources.DataTables.Item(m_DataTableUid)
queryStr = "Select 0, CardName, CardType, GroupNum from OCRD"
oDataTable.ExecuteQuery queryStr

Example

See Also