IDataStore.GetItemTime(int row, short 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 DateTime 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.

Namespace: PowerBuilder.Data

Assembly: PowerBuilder.Data.dll

Syntax

  public DateTime? GetItemDateTime(int row, short column, DwBuffer bufferType = DwBuffer.Primary, bool isOriginalValue = false);

Parameters

row System.Int32

The zero-based row number to get data.

column System.Int16

The zero-based column number to get data.

bufferType PowerBuilder.Data.DwBuffer

The specified buffer of the DataStore.

The default is DwBuffer.Primary.

isOriginalValue System.Boolean

Whether to obtain the data that was originally retrieved.

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

Returns

System.DateTime?

Returns the DateTime? value in the specified row and column.

Remarks

Use GetItemDateTime when you want 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 GetItemDateTime method to get the datetime-type value in the specified row and column.

using PowerBuilder.Data;
using System;

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

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

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

            datastore.Retrieve();

            datastore.SetItem(0, "modifieddate", DateTime.Parse("2018/01/01"));

            // Gets the original value in row 1 and in column 1 and 3 of DataStore.
            // Column 3 (Column name is ModifiedDate) is datetime type.        
            Console.WriteLine(
                "Original value: Description: {0};\n" +
                "ModifiedDate: {1}",
                datastore.GetItem<string>(0, 1),
                datastore.GetItemDateTime(0, 2, DwBuffer.Primary, true));

            // Gets the modified value in row 1 and in column 1 and 3 of DataStore.
            Console.WriteLine(
                "Modified value: Description: {0};\n" +
                "ModifiedDate: {1}",
                datastore.GetItem<string>(0, 1),
                datastore.GetItemDateTime(0, 2, DwBuffer.Primary, false));

            /*This code produces the following output:
             
            Original value: Description: Calculus Description;
            ModifiedDate: 8/8/2008 8:08:08 AM
            Modified value: Description: Calculus Description;
            ModifiedDate: 1/1/2018 12:00:00 AM
            */
        }
    }
}

Applies to

.NET Standard

2.x