IDataStore.GetItemString(int row, string column, DwBuffer bufferType = DwBuffer.Primary, bool isOriginalValue = false) Method

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

0.5.0-alpha

1.0.1 (current)

Gets data whose type is String for the specified row and column from the specified buffer of the DataStore. You can obtain the data that was originally retrieved and stored in the database, as well as the current value in the primary, delete, or filter buffers.

Assembly: PowerBuilder.Data.dll

Syntax

  public string GetItemString(int row, string column, DwBuffer bufferType = DwBuffer.Primary, bool isOriginalValue = false);

Parameters

row System.Int32

The zero-based row number to get data.

column System.String

The name of a column to get data.

To get the contents of a computed field, specify the name of the computed field for column. Computed fields do not have numbers.

bufferType PowerBuilder.Data.DwBuffer

The specified buffer of the DataStore. The default is DwBuffer.Primary.

isOriginalValue System.Boolean

True: to obtain the data that was originally retrieved; False (default): to obtain the current data.

Returns

System.String

Returns the string value in the specified row and column.

Remarks

Use GetItemString to get information from the DataWindow buffer. To access a row in the original buffer, specify the buffer that the row currently occupies (primary, delete, or filter) and the number of the row in that buffer. When you specify true for isOriginalValue, the method gets the original data for that row.

Examples

The following code example demonstrates how to use the GetItemString method to get the string-type value in the specified row and column.

using PowerBuilder.Data;
using System;

namespace Appeon.ApiDoc.IDataStoreExamples
{
    public class GetItemStringExample
    {
        private SchoolContext _context;

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

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

            datastore.Retrieve();

            datastore.SetItem(0, "name", "Department Name");

            // Gets the original value in row 1 and in the departmentid column and 
            // name column of DataStore.
            // The 'name' column is string type.
            Console.WriteLine(
                "Original value: Department ID: {0}; Department Name: {1}",
                datastore.GetItem(0, "departmentid"),
                datastore.GetItemString(0, "name", DwBuffer.Primary, true));

            // Gets the modified value in row 1 and in the departmentid column and 
            // name column of DataStore.
            // The name column is string type.
            Console.WriteLine(
                "Modified value: Department ID: {0}; Department Name: {1}",
                datastore.GetItem(0, "departmentid", DwBuffer.Primary, false),
                datastore.GetItemString(0, "name", DwBuffer.Primary, false));

            /*This code produces the following output:
             
            Original value: Department ID: 1; Department Name: Engineering
            Modified value: Department ID: 1; Department Name: Department Name
            */
        }
    }
}

Applies to

.NET Standard

2.x