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

• DataTable Object

  • UI API

  • • 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)
      Set oDataTable = oForm.DataSources.DataTables.Item(m_DataTableUid) queryStr = "Select 0, CardName, CardType, GroupNum from OCRD" oDataTable.ExecuteQuery queryStr

  • • See Also

      DataTable Members