IDwDataImporter.Import(string text, int startRow, int endRow = -1) Method

.NET Standard 2.x

Imports data into the DataStore buffer with the specified DataFormat, and specifies the start and end positions. Data outside this range will not be imported into the DataStore.

Namespace: DWNet.Data

Assembly: DWNet.Data.dll

Syntax

int Import(string text, int startRow, int endRow = -1);

Parameters

text System.String

Data string in the specified format.

The JSON string must comply with the plain-format JSON or DataWindow JSON.

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.

Returns

System.Int32

Returns the number of rows that were imported if it succeeds.

Examples

The following code example demonstrates how to import the department JSON string of the start row and end row into the DataStore.

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

namespace Appeon.ApiDoc.IDwDataImporterExamples
{
    public class ImportExample
    {
        private readonly SchoolContext _context;

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

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

            // Get DataStore importer in JSON format.
            var importer = datastore.GetDataImporter(DataFormat.Json);

            // Gets the JSON file,ExportPlainJson1.json contains 4 records.
            string path = Path.Combine(AppContext.BaseDirectory,
                                @"Jsons\IDwDataExporter\ExportPlainJson1.json");
            string json = File.ReadAllText(path);

            // Imports data from JSON to the primary buffer.
            // Imports data from row 1 through the end.
            int row = importer.Import(json, 0, 3);

            Console.WriteLine("Import Row: {0}; Rowcount: {1}", row, datastore.RowCount);

            datastore.Reset();

            // Imports data from row 2 and 3 of the JSON string to the primary buffer.
            row = importer.Import(json, DwBuffer.Primary, 1, 2);

            Console.WriteLine("Import Row: {0}; Rowcount: {1}", row, datastore.RowCount);

            /*This code produces the following output:

            Import Row: 4; Rowcount: 4
            Import Row: 2; Rowcount: 2
           */
        }
    }
}

Example Refer To

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