Xceed DataGrid for WPF v7.2 Documentation
Unbound Data
Welcome to Xceed DataGrid, Editors, and 3D Views for WPF v7.2 > Xceed DataGrid for WPF > DataGrid Fundamentals > Manipulating Data > Providing, Inserting, and Removing Data > Unbound Data

Unbound data can be "appended" to a data item through the use of unbound item properties, which are represented by the DataGridUnboundItemProperty class. Unlike unbound columns, which can be used to display non-data related information such as a label or controls that allow some sort of action to be carried out, unbound item properties can be used to provide additional data, such as calculated columns (see Example 1).

An item property's QueryValue event is raised for each data item in the underlying data source and allows unbound values to be provided for each item through the Value property received in the event arguments (see Example 1). The CommittingValue event is also raised for each data item to allow the unbound value to be committed, if required. In both cases, the item received in the event parameters represents the original data item without any unbound item property fields.

Like data-bound item properties, each unbound item property has its corresponding column (see Column class) in the grid's Columns collection, which can be used to define layout and behavioral information for the item property. 

Although both the UnboundColumn and DataGridUnboundItemProperty classes both use the term "unbound" they are not meant to be used together.

Examples

All examples in this topic assume that the grid is bound to the Products table of the Northwind database, unless stated otherwise

Example 1: Providing unbound data

The following example demonstrates how to use an unbound item property to display a calculated value. In this example, the total value of the units in stock.

XAML
Copy Code
<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid">

  <Grid.Resources>

     <xcdg:DataGridCollectionViewSource x:Key="cvs_products"

                                        Source="{Binding Source={x:Static Application.Current}, Path=Products}">

        <xcdg:DataGridCollectionViewSource.ItemProperties>

          <xcdg:DataGridUnboundItemProperty Name="TotalUnitsValue"

                                            DataType="{x:Type sys:Double}"

                                            QueryValue="DataGridUnboundItemProperty_QueryValue" />

        </xcdg:DataGridCollectionViewSource.ItemProperties>

     </xcdg:DataGridCollectionViewSource>

     <local:CurrencyConverter x:Key="currencyConverter" />

  </Grid.Resources>

  <xcdg:DataGridControl x:Name="OrdersGrid"

                        ItemsSource="{Binding Source={StaticResource cvs_products}}">

     <xcdg:DataGridControl.Columns>

        <xcdg:Column FieldName="TotalUnitsValue"

                     Title="Total Inventory">

           <xcdg:Column.CellContentTemplate>

              <DataTemplate>

                 <TextBlock Text="{Binding Converter={StaticResource currencyConverter}}" />

              </DataTemplate>

           </xcdg:Column.CellContentTemplate>

        </xcdg:Column>

        <xcdg:Column FieldName="Photo"

                     Visible="False" />           

     </xcdg:DataGridControl.Columns>

  </xcdg:DataGridControl>

</Grid>

The following code provides the implementation of the QueryValue event in which the unbound value will be calculated and returned.

VB.NET
Copy Code
Private Sub DataGridUnboundItemProperty_QueryValue( ByVal sender As Object, ByVal e As DataGridItemPropertyQueryValueEventArgs )

  Dim System.Data.DataRowView As row = TryCast( e.Item, System.Data.DataRowView )

  If Not row Is Nothing Then

    If( row( "UnitsInStock" ) <> DBNull.Value ) Then

      e.Value = CDouble( CInt( row( "UnitsInStock" ) ) * CDec( row( "UnitPrice" ) )

    End If

  End If

End Sub
C#
Copy Code
private void DataGridUnboundItemProperty_QueryValue( object sender, DataGridItemPropertyQueryValueEventArgs e )

{

 System.Data.DataRowView row = e.Item as System.Data.DataRowView;

 if( row != null )

 {

   if( row[ "UnitsInStock" ] != DBNull.Value )

   {

     e.Value = ( double )( ( short )row[ "UnitsInStock" ] * ( decimal )row[ "UnitPrice" ] );

   }

 }

}
Show AllShow All
Hide AllHide All
See Also

DataGrid Fundamentals