TreeListCustomUnboundColumnDataEventArgs.Column Property

Gets the processed column.

Namespace: DevExpress.Web.ASPxTreeList

Assembly: DevExpress.Web.ASPxTreeList.v20.2.dll

NuGet Package: DevExpress.Web

Declaration

C#

public TreeListDataColumn Column { get; }

VB.NET

Public ReadOnly Property Column As TreeListDataColumn

Property Value

Type	Description
TreeListDataColumn	A TreeListDataColumn object representing the column.

Example

Assume that ASPxTreeList is bound to an “Order Details” data table (NWind data base), which contains “UnitPrice”, “Quantity” and “Discount” fields. There is no field that represents the total sum, as this can be calculated manually as follows: UnitPrice*Quantity*(1-Discount). This example shows how to add an unbound column to the ASPxTreList control to represent the total sum of an order.

The image below shows the result.

C#

protected void TreeList_CustomUnboundColumnData(object sender, TreeListCustomUnboundColumnDataEventArgs e)
{
    if (e.Column.FieldName == "Total")
    {
        decimal unitPrice = Convert.ToDecimal(e.Node.GetValue("UnitPrice"));
        decimal quantity = Convert.ToDecimal(e.Node.GetValue("Quantity"));
        decimal discount = Convert.ToDecimal(e.Node.GetValue("Discount"));
        e.Value = unitPrice * quantity * (1 - discount);
    }
} 

ASPX

<dx:ASPxTreeList runat="server" ID="TreeList" Width="400px" OnCustomUnboundColumnData="TreeList_CustomUnboundColumnData" DataSourceID="SqlDataSource1" 
    SettingsPager-Mode="ShowPager" AutoGenerateColumns="False" KeyFieldName="OrderID">
    <Columns>
        <dx:TreeListTextColumn FieldName="ProductID" VisibleIndex="0" ReadOnly="True">
        </dx:TreeListTextColumn>
        <dx:TreeListTextColumn FieldName="UnitPrice" VisibleIndex="1">
        </dx:TreeListTextColumn>
        <dx:TreeListTextColumn FieldName="Quantity" VisibleIndex="2">
        </dx:TreeListTextColumn>
        <dx:TreeListTextColumn FieldName="Discount" VisibleIndex="3">
        </dx:TreeListTextColumn>
        <dx:TreeListDataColumn FieldName="Total" UnboundType="Decimal"/>
    </Columns>
    <SettingsPager Mode="ShowPager">
    </SettingsPager>
</dx:ASPxTreeList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb; Persist Security Info=True" 
ProviderName="System.Data.OleDb" SelectCommand="SELECT [ProductID], [UnitPrice], [Quantity], [Discount] FROM [Order Details]"></asp:SqlDataSource>