IDataStore.ExportJson(DwBuffer dwbuffer, int startRow, MappingMethod mappingMethod) Method
.NET Standard 2.x | Current Version (1.0.1) 
Exports the rows (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, 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.
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 rows 2 through the end in the primary buffer 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 Example6()
{
// Instantiates a DataStore object with datawindow: d_department.
var datastore = new DataStore("d_department", _context);
datastore.Retrieve();
// Exports records starting from rows 2 through the end in the primary buffer.
string json = datastore.ExportJson(DwBuffer.Primary, 1, MappingMethod.Index);
Console.WriteLine(json);
/*The exported JSON file is:
ExportJson6.json
*/
}
}
}
Example Refer To
JSON File: ExportJson6
Applies to
.NET Standard
2.x