DataStoreDataExtensions.ExportJson(this IDataStoreBase dataStore, DwBuffer dwbuffer, int startRow, int endRow, MappingMethod mappingMethod) Method

.NET Standard 2.x

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

Namespace: DWNet.Data

Assembly: DWNet.Data.dll

Syntax

  public static string ExportJson(this IDataStoreBase dataStore, DwBuffer dwbuffer, int startRow, int endRow, MappingMethod mappingMethod);

Parameters

dwbuffer DWNet.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.

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 first and second rows in the primary buffer to a JSON string.

using SnapObjects.Data;
using DWNet.Data;
using System;

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

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

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

            datastore.Retrieve();

            // Exports data from the first and second rows of the primary buffer.
            string json = datastore.ExportJson(DwBuffer.Primary, 0, 1, MappingMethod.Index);

            Console.WriteLine(json);

            /*The exported JSON file is:

            ExportJson7.json  
            */
        }
    }
}

Example Refer To

Model Class: D_Department
JSON File: ExportJson7
DataWindow File: d_department

Applies to

.NET Standard

2.x