sfdatagrid DateTimeOffset support in GridDateTimeColumn

[Balasubramanian Ramanathan]

Hi,

If the model contains datetimeoffset column then while adding or editing it throws up an error.

Whether datetimeoffsetcolumn is supported in uwp sfdatagrid?

If not how to make it work with datetimeoffset column.

Thanks

[Balasubramanian Ramanathan]

I managed to find the example in your help system.

Thank you

[Jai Ganesh S]

Hi Balasubramanian, 

 

Thank you for the update. 

 

Please let us know if you need any other assistance on this. 

 

Regards, 

Jai Ganesh S 

 

[Balasubramanian Ramanathan]

Thank you for the reply.

I am facing issues with having nullable datetimeoffset field.

How to modify the converted class to handle nullable datetimeoffset file in the model.

Thanks.

[Jai Ganesh S]

Hi Balasubramanian, 

 

You can achieve your requirement to bind the null value in DateTimeOffset by change the converter like below, 

 

public class DateTimeOffsetFormatConverter : IValueConverter 

{ 

    private GridDateTimeOffsetColumn cachedColumn; 

 

    public DateTimeOffsetFormatConverter(GridDateTimeOffsetColumn column) 

    { 

        cachedColumn = column; 

    } 

 

    object IValueConverter.Convert(object value, Type targetType, object parameter, string language) 

    { 

 

        var column = cachedColumn as GridDateTimeColumn; 

           

        if (value == null || DBNull.Value == value) 

        { 

            if (column.AllowNullValue) 

                return column.WaterMark; 

        } 

             

        value = ((DateTimeOffset)value).DateTime; 

 

 

        DateTime _columnValue; 

 

        _columnValue = (DateTime)value; 

 

        if (_columnValue < column.MinDate) 

            _columnValue = column.MinDate; 

 

        if (_columnValue > column.MaxDate) 

            _columnValue = column.MaxDate; 

 

        return _columnValue.ToString(column.FormatString, CultureInfo.CurrentUICulture); 

    } 

 

    object IValueConverter.ConvertBack(object value, Type targetType, object parameter, string language) 

    { 

        throw new NotImplementedException(); 

    } 

} 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/UWP781772461.zip 

 

Regards, 

Jai Ganesh S