IDwDataExporter.Export(DwBuffer dwbuffer, int startRow, int endRow, int startColumn, int endColumn, MappingMethod importMapping) Method

.NET Standard 2.x

Exports data from the specified buffer of the DataStore in the specified DataFormat, and specifies the start and end positions of the rows and columns, and how to map columns.

Namespace: DWNet.Data

Assembly: DWNet.Data.dll

Syntax

string Export(DwBuffer dwbuffer, int startRow, int endRow, int startColumn, int endColumn, MappingMethod importMapping);

Parameters

dwbuffer DWNet.Data.DdwBuffer

A value of the DwBuffer enumerated datatype identifying the DataWindow buffer from which you want to export the data. For a list of valid values, see DWBuffer.

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.

startColumn System.Int32

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

endColumn System.Int32

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

importMapping SnapObjects.Data.MappingMethod

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

Returns

System.String

Data string in the specified format.

Reference DataWindow JSON Plain JSON

Examples

The following code example demonstrates how to export the department records to a JSON string using startRow, endRow, startColumn and endColumn parameters.

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

namespace Appeon.ApiDoc.IDwDataExporterExamples
{
    public class ExportExample
    {
        private readonly SchoolContext _context;

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

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

            datastore.Retrieve();

            // Get DataStore exporter in JSON format.
            var exporter = datastore.GetDataExporter(DataFormat.Json);

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

            Console.WriteLine(json);

            /*The exported JSON file is:

            ExportJson9.json  
            */
        }
    }
}

Example Refer To

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