IDataStore.ExportJson(DwBuffer dwbuffer, int startRow, int endRow, short startColumn, MappingMethod mappingMethod) Method

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

0.5.0-alpha

1.0.1 (current)

Exports the rows (from the specified starting position to the ending position) and the columns (from the specified starting position to the end) from the specified buffer to a DataWindow JSON string.

Namespace: PowerBuilder.Data

Assembly: PowerBuilder.Data.dll

Syntax

  public string ExportJson(DwBuffer dwbuffer, int startRow, int endRow, short startColumn, MappingMethod mappingMethod);

Parameters

dwbuffer PowerBuilder.Data.DwBuffer

A value of the DwBuffer enumerated datatype identifying the DataWindow buffer from which you want to export the data.

startRow System.Int32

The zero-based index number of the first row in the buffer that you want to export.

endRow System.Int32

The zero-based index number of the last row in the buffer that you want to export.

If it is negative, it indicates the rest of rows.

startColumn System.Int16

The zero-based index number of the first column in the buffer that you want to export.

If it is negative, 0 is used.

mappingMethod SnapObjects.Data.MappingMethod

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

Returns

System.String

Returns the JSON string if it succeeds.

Examples

The following code example demonstrates how to export the department records in the specified rows and columns of the primary buffer to a JSON string using the startRow,endRow and startColumn parameters.

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 Example8()
        {
            // Instantiates a DataStore object with datawindow: d_department.
            var datastore = new DataStore("d_department", _context);

            datastore.Retrieve();

            // Exports records in rows 1 through 11 and in columns 2 through the end of the primary buffer
            string json = datastore.ExportJson(
                DwBuffer.Primary, 0, 10, 1, MappingMethod.Index);

            Console.WriteLine(json);

            /*The exported JSON file is:

            ExportJson8.json  
            */
        }
    }
}

Example Refer To

JSON File: ExportJson8

Applies to

.NET Standard

2.x