DataGrid

表格

与ArrayCollection关联，可显示多条信息

 

1、定义

[Bindable]

private var dpConsumeDetail:ArrayCollection; //消费明细

 

2、赋值

dpConsumeDetail=new ArrayCollection();

var str:String="select consume_detail.id,date_time,types.name name,money,remark " +

        "from consume_detail " +

        "inner join " +

        "types on consume_detail.type_id=types.id and consume_detail.userid=types.userid "+

        "where date_time<="+selEndDate+" and date_time>="+selStartDate+

        " and consume_detail.userid="+userId;

db.SelItemFromTable(str,dpConsumeDetail);

 

从数据库取值，赋给dpConsumeDetail

 

//访问dpConsumeDetail中的元素

sumMoney=0;

for(var i:int=0;i<dpConsumeDetail.length;i++)

{

    sumMoney+=Number(dpConsumeDetail.getItemAt(i).money);

}

 

3、在DataGrid显示

<mx:DataGrid id="selDataSetId" x="40" y="218" height="169" width="366"

            selectable="true"

            selectionColor="0x7FCEFF"

            dataProvider="{dpConsumeDetail}"

            itemClick="itemClickDeal(event);">

    <mx:columns>

        <mx:DataGridColumn headerText="日期" dataField="date_time"/>

        <mx:DataGridColumn headerText="类型" dataField="name"/>

        <mx:DataGridColumn headerText="金额" dataField="money"/>

        <mx:DataGridColumn headerText="备注" dataField="remark"/>

    </mx:columns>

</mx:DataGrid>

 

dataProvider="{dpConsumeDetail}" 与第二步取出的值对应

dataField="date_time" 分别对应从数据库取出的字段名称