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?

Parents
No Data
Reply
  • 280
    posted

    I'm also having this problem.  Our columns are built in the page code behind, it's kind of a complicated layout, so I'm not sure how to add the datetimeedit control.  Isn't there an accessible property that would dictate the format of the text in the editable cell?

Children
No Data