TdxBackendCustomInMemoryJSONConnection.SetJSONValue(string) Method

Sets component data to the specified JSON value.

Declaration

procedure SetJSONValue(const AJSONValue: string);

Parameters

Name	Type	Description
AJSONValue	string	The specified JSON value.

Remarks

Call the SetJSONValue procedure and pass the required JSON data string to replace existing content stored in the component.

Code Example: Assign a JSON Data String

The following code example demonstrates an OnClick event handler that calls the SetJSONValue procedure to assign a table defined within a JSON string to the TdxBackendInMemoryJSONConnection component and displays the Dashboard Designer dialog:

Delphi

uses
  dxDashboard.Control,  // Declares the TdxDashboardControl component
  dxBackend.ConnectionString.JSON;  // Declares the TdxBackendInMemoryJSONConnection component
// ...

procedure TMyForm.cxButton1Click(Sender: TObject);
var
  AJSONData: string;
begin
  // Define a table that consists of three columns ("id", "Region", and "Sales") and five data rows
  AJSONData :=

  '[{"id": 1, "Region": "Asia", "Sales": 4.7685},' +  // Row #1
   '{"id": 2, "Region": "Australia", "Sales": 1.9576},' + // Row #2
   '{"id": 3, "Region": "Europe", "Sales": 3.3579},' +  // Row #3
   '{"id": 4, "Region": "North America", "Sales": 3.7477},' + // Row #4
   '{"id": 5, "Region": "South America", "Sales": 1.8237}]'; // Row #5

  // Specify a user-friendly data connection name (for end-user dialogs)
  dxBackendInMemoryJSONConnection1.DisplayName := 'Memory-Based JSON Data Storage';
  dxBackendInMemoryJSONConnection1.SetJSONValue(AJSONData);  // Assigns the defined JSON data string
  dxDashboardControl1.ShowDesigner; // Displays the Dashboard Designer dialog
end;

C++

#include "dxDashboard.Control.hpp"  // Declares the TdxDashboardControl component
#include "dxBackend.ConnectionString.JSON.hpp"  // Declares the TdxBackendInMemoryJSONConnection component

// Add the following linker directives to the corresponding CPP source file:
#pragma link "dxDashboard.Control"  // Required to use dxDashboard.Control.hpp declarations
#if defined(_WIN64)  // Required to use dxBackend.ConnectionString.JSON.hpp declarations
  #pragma link "dxBackend.ConnectionString.JSON.o"
#else
  #pragma link "dxBackend.ConnectionString.JSON.obj"
#endif
// ...

void __fastcall TMyForm::cxButton1Click(TObject *Sender)
{
  // Define a table that consists of three columns ("id", "Region", and "Sales") and five data rows
  UnicodeString AJSONData =

    "[{\"id\": 1, \"Region\": \"Asia\", \"Sales\": 1.9576},"  // Row #1
     "{\"id\": 2, \"Region\": \"Australia\", \"Sales\": 1.9576}," // Row #2
     "{\"id\": 3, \"Region\": \"Europe\", \"Sales\": 3.3579}," // Row #3
     "{\"id\": 4, \"Region\": \"North America\", \"Sales\": 3.7477}," // Row #4
     "{\"id\": 5, \"Region\": \"South America\", \"Sales\": 1.8237}]" // Row #5

  // Specify a user-friendly data connection name (for end-user dialogs)
  dxBackendInMemoryJSONConnection1->DisplayName = "Memory-Based JSON Data Source";
  dxBackendInMemoryJSONConnection1->SetJSONValue(AJSONData);  // Assigns the defined JSON data string
  dxDashboardControl1->ShowDesigner();  // Displays the Dashboard Designer dialog
}