Help on Date Column

Printable View

Aug 22, 2011, 7:24 PM
reezvi

Help on Date Column

Hi there,

I need help from you guys on following. I got a GridPanel using RowEditor that has Date column/s in it. My application has to comply with localization. In the Date column, I have to display date as a formatted localized value (string) and while editing, I want to use the regular date control (no matter if I have to use English as contol's local) we have in Ext.Net.

I already been trying on this. So far Im able to display the formatted localized Date String (DataIndex="DateOfJoining" in given snippet) but Im stucked on how to display the formatted date after edit. My sample snippet on DateColumn is given below. Any help or example will be truly appreciated.

Code:

<ext:Column DataIndex="DateOfJoining" Header="DOJ" Width="80" editable="true"> <Editor> <ext:DateField runat="server" Format="dd-MM-yyyy"> <DirectEvents> <Blur OnEvent="Date_Changed"/> </DirectEvents> </ext:DateField> </Editor> </ext:Column>

Thanks
Aug 22, 2011, 8:31 PM
geoffrey.mcgill

Hi,

If you change your <ext:Column> to an <ext:DateColumn>, you'll have access to the .Format property.

Example

Code:

<ext:DateColumn DataIndex="DateOfJoining" Header="DOJ" Width="80" editable="true" Format="dd-MM-yyyy"> <Editor> <ext:DateField runat="server" Format="dd-MM-yyyy"> <DirectEvents> <Blur OnEvent="Date_Changed"/> </DirectEvents> </ext:DateField> </Editor> </ext:DateColumn>

Hope this helps.
Aug 22, 2011, 8:58 PM
reezvi

Hi Geoffrey,

Thanks for your prompt assistance. Well, think I couldn't state my problem clearly, sorry for that. I tried earlier the way you suggested, but it didn't work. It raised an exception for inproper data format. It was obvious. Since The Column's DataIndex (DataIndex="DateOfJoining") is mapped to a String Type object property (<ext:RecordField Name="DateOfJoining" Mapping="StringDateOfJoining" Type="String"/>). This object property actually holds a string of converted datetime to local (bn-IN) language. So when date column was trying to format it (dd-MM-yyyy), it was throwing an exception since it couldn't recognise the value as any valid date.

I need to display the formatted string (localized) of date (it is working now), when editing, I need to use the regular EXT.Net date control (as it is in english, since I can't localize it to bn-IN). It is also done. But After edit, I have to convert the date to local string again and display it and Im stucked on this part.

Please feel free if you require any further clarification. Thanks again.
Aug 22, 2011, 10:20 PM
Vladimir

You can use column renderer to format display value as required
Aug 23, 2011, 4:26 AM
reezvi

Quote:

Originally Posted by Vladimir

You can use column renderer to format display value as required

Thanks Vladimir, but how can I call a serverside method in column renderer rather than calling a javascript function? I have the formatting method in my serverside utility class. Any small example or reference?
Aug 23, 2011, 4:53 AM
geoffrey.mcgill

Quote:

Originally Posted by reezvi

Thanks Vladimir, but how can I call a serverside method in column renderer rather than calling a javascript function? I have the formatting method in my serverside utility class. Any small example or reference?

Hi reezvi,

With a Column Renderer a server-side call is not possible. The logic for rendering the column must be created client-side within a JavaScript call.
Aug 24, 2011, 4:43 PM
reezvi

Quote:

Originally Posted by geoffrey.mcgill

Hi reezvi,

With a Column Renderer a server-side call is not possible. The logic for rendering the column must be created client-side within a JavaScript call.

Thanks Geoffrey. In that case Im trying to get my requirements done with ColumnRenderer to a JavaScript call. I'll let you know the progress and if the issue can be flagged as Closed. Thanks again.