Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
225
UltraWebGrid and date format when editing cells
posted

I am using the Infragistics4.WebUI.UltraWebGrid.v10.2, Version=10.2.20102.1011. The grid is bound to a datasource. Some of the data that comes out of the database is in the DateTime format. The database is Sql Server 2008.

The grid I am using allows for Insert/Update. It also lets you Insert/Update the columns containing the date and time. The UltraGridColumns that contain the date and time are set up with Format="dd/MM/yyyy" so that only the day, month and year are visible to the user.

When the user clicks in the date cell, the cell enters edit mode. At this point, the "dd/MM/yyyy" format is lost. The date comes out looking something like "Fri Jan 01 2010 00:00:00 GMT+1100 (AUS Eastern Daylight Time)" instead of "01/01/2010".

How can the UltraGridColumn be set up in a way that the format of the date and time is always "dd/MM/yyyy", even when the user is editing the cell?