Share on Google+Share on Google+

DataFormatter in Column in AdvancedDataGrid

Advertisement
In this example you can see how we can use a dataFormatter in AdvancedDataGrid.

DataFormatter in Column in AdvancedDataGrid:

In this example you can see how we can use a dataFormatter in AdvancedDataGrid.
In this example we use a TotalFine column and use a CurrencyFormatter for providing a actual format of currency.

Example:

<?xml version="1.0" encoding="utf-8"?>

<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"

xmlns:s="library://ns.adobe.com/flex/spark"

xmlns:mx="library://ns.adobe.com/flex/mx"

minWidth="955" minHeight="600">

<fx:Script>

<![CDATA[

import mx.collections.ArrayCollection;

[Bindable]

private var student:ArrayCollection = new ArrayCollection([

{Course:"Course", categories: [

{Course:"B.Sc.", categories:[

{Branch:"Physics", Girls:60, Boys:120, TotalStudent:180, PASSinper:98.0, FAILinper:2.0,

 TotalFine:11000},

{Branch:"Chemistry", Girls:100, Boys:50, TotalStudent:150, PASSinper:97.0, FAILinper:3.0,

 TotalFine:12000},

{Branch:"Mathematics", Girls:50, Boys:150, TotalStudent:200, PASSinper:98.5, FAILinper:1.5,

 TotalFine:12500}]},

{Course:"B.tech.", categories:[

{Branch:"CS", Girls: 45, Boys:75, TotalStudent:120, PASSinper:99.0, FAILinper:1.0,

 TotalFine:10000},

{Branch:"IT", Girls: 55, Boys:65, TotalStudent:120, PASSinper:99.5, FAILinper:0.5,

 TotalFine:15000},

{Branch:"EC", Girls: 25, Boys:95, TotalStudent:120, PASSinper:96.7, FAILinper:3.3,

 TotalFine:9000},

{Branch:"EI", Girls: 40, Boys:80, TotalStudent:120, PASSinper:95, FAILinper:5, TotalFine:8500},

{Branch:"Mechanical", Girls:10, Boys: 80, TotalStudent:90, PASSinper:97.5, FAILinper:2.5,

 TotalFine:8000},

{Branch:"Civil", Girls: 15, Boys:45, TotalStudent:60, PASSinper:92, FAILinper:8, TotalFine:12000

}]},

{Course:"B.Pharma.", categories:[

{Branch:"Pharmacy", Girls:70, Boys:130, TotalStudent:200, PASSinper:99.8, FAILinper:0.2,

 TotalFine:10000}]},

{Course:"M.B.A.", categories:[

{Branch:'HR', Girls:48, Boys:72, TotalStudent:120, PASSinper:100, FAILinper:0, TotalFine:10500},

{Branch:'Finance', Girls:40, Boys:80, TotalStudent:120, PASSinper:85, FAILinper:15,

 TotalFine:12500},

{Branch:'Marketing', Girls:20, Boys:100, TotalStudent:120, PASSinper:99, FAILinper:1,

 TotalFine:15500},

{Branch:'IT & HR', Girls:30, Boys:90, TotalStudent:120, PASSinper:100, FAILinper:0,

 TotalFine:6000}]},

{Course:"M.C.A.", categories:[

{Branch:"Computer Science", Girls:30, Boys:90, TotalStudent: 120, PASSinper:99.1,

 FAILinper:0.9, TotalFine:10000}]}

]}

]);

]]>

</fx:Script>

<s:Panel title="Data Formatter in Column in AdvancedDataGrid" height="419" width="728">

<mx:AdvancedDataGrid

sortExpertMode="true"

height="363"

x="13" y="13"

width="703">

<mx:dataProvider>

<mx:HierarchicalData source="{student}" childrenField="categories"/>

</mx:dataProvider>

<mx:columns>

<mx:AdvancedDataGridColumn dataField="Course"/>

<mx:AdvancedDataGridColumn dataField="Branch" headerText="Branch"/>

<mx:AdvancedDataGridColumn dataField="Girls"/>

<mx:AdvancedDataGridColumn dataField="Boys"/>

<mx:AdvancedDataGridColumn dataField="TotalStudent"/>

<mx:AdvancedDataGridColumn dataField="PASSinper"/>

<mx:AdvancedDataGridColumn dataField="FAILinper"/>

<mx:AdvancedDataGridColumn dataField="TotalFine">

<mx:formatter>

<mx:CurrencyFormatter currencySymbol="Rs" useThousandsSeparator="true"/>

</mx:formatter>

</mx:AdvancedDataGridColumn>

</mx:columns>

</mx:AdvancedDataGrid>

</s:Panel>

</s:Application>

Output:

Running Application:

To view this page ensure that Adobe Flash Player version 10.0.0 or greater is installed.

Download this code

Advertisements

Posted on: June 16, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.