IDataStore.ExportJson(bool changeOnly, MappingMethod mappingMethod) Method

.NET Standard 2.x | Current Version (1.0.1)

0.5.0-alpha

1.0.1 (current)

Exports all rows or only the changed rows from DataStore to a DataWindow JSON string.

Namespace: PowerBuilder.Data

Assembly: PowerBuilder.Data.dll

Syntax

  public string ExportJson(bool changeOnly, MappingMethod mappingMethod);

Parameters

changeOnly System.Boolean

A boolean specifying the changing flag.

True: to export the changed rows only (and all rows in the delete buffer).

False (default): to export all rows.

mappingMethod SnapObjects.Data.MappingMethod

A value of the MappingMethod enumerated datatype specifying the method for mapping columns.

Returns

System.String

Returns the JSON string.

Examples

The following code example demonstrates how to export the department records to JSON strings using different changeOnly arguments. When changeOnly is true, exports the modified data from primary/filter/delete buffers to a JSON string; when changeOnly is false, exports all data from primary/filter/delete buffers to a JSON string.

using SnapObjects.Data;
using PowerBuilder.Data;
using System;

namespace Appeon.ApiDoc.IDataStoreExamples
{
    public class ExportJsonExample
    {
        private SchoolContext _context;

        public ExportJsonExample(SchoolContext dataContext)
        {
            // Sets the data context
            _context = dataContext;
        }

        public void Example2()
        {
            // Instantiates the datastore with datawindow: d_department
            var datastore = new DataStore("d_department", _context);

            // Generates data in the primary/delete/filter buffers for this example.
            datastore.Retrieve();
            datastore.DeleteRow(0);
            datastore.SetItem(0, 1, "department name");
            datastore.SetFilter("departmentid < 5");
            datastore.Filter();

            // When changeOnly is true, exports the modified data from 
            // primary/filter/delete buffers
            string json1 = datastore.ExportJson(true, MappingMethod.Index);

            Console.WriteLine("datastore.ExportJson(true, " +
                              "MappingMethod.Index):");
            Console.WriteLine(json1);

            /*The exported JSON file is:

            ExportJson2_1.json  
            */

            // When changeOnly is false, exports all data from 
            // primary/filter/delete buffers
            string json2 = datastore.ExportJson(false, MappingMethod.Index);

            Console.WriteLine("datastore.ExportJson(false, " +
                              "MappingMethod.Index):");
            Console.WriteLine(json2);

            /*The exported JSON file is:

            ExportJson2_1.json  
            */
        }
    }
}

Example Refer To

JSON File: ExportJson2_1

Applies to

.NET Standard

2.x