TreeListCustomUnboundColumnDataEventArgs.Value Property

Gets the edit value of the cell currently being processed.

Namespace: DevExpress.Web.ASPxTreeList

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

Declaration

C#

public object Value { get; set; }

VB.NET

Public Property Value As Object

Property Value

Type	Description
Object	An object that represents the cell’s edit value.

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>