Intersoft ClientUI Documentation
SortDescriptors Property
See Also  Send Feedback
Intersoft.Client.Data.ComponentModel Namespace > QueryDescriptor Class : SortDescriptors Property






Syntax

Visual Basic (Declaration) 
Public Property SortDescriptors As SortDescriptorCollection
Visual Basic (Usage)Copy Code
Dim instance As QueryDescriptor
Dim value As SortDescriptorCollection
 
instance.SortDescriptors = value
 
value = instance.SortDescriptors
C# 
public SortDescriptorCollection SortDescriptors {get; set;}
Delphi 
public read-write property SortDescriptors: SortDescriptorCollection; 
JScript 
public function get,set SortDescriptors : SortDescriptorCollection
Managed Extensions for C++ 
public: __property SortDescriptorCollection* get_SortDescriptors();
public: __property void set_SortDescriptors( 
   SortDescriptorCollection* value
);
C++/CLI 
public:
property SortDescriptorCollection^ SortDescriptors {
   SortDescriptorCollection^ get();
   void set (    SortDescriptorCollection^ value);
}

Example

The following example shows how to instantiate a QueryDescriptor programmatically and demonstrate the use of FilterDescriptors, SortDescriptors and PageDescriptors in the QueryDescriptor object.

CS Copy Code
QueryDescriptor queryDescriptor = new QueryDescriptor();

// filtering
// get records that have
// (UnitPrice >= 0 AND UnitPrice < 50) OR (UnitPrice == 0)
CompositeFilterDescriptorCollection groupFilter1 = new CompositeFilterDescriptorCollection();

groupFilter1.LogicalOperator = FilterCompositionLogicalOperator.And;
groupFilter1.Add(
    new FilterDescriptor()
    {
        PropertyName = "UnitPrice",
        Operator = FilterOperator.IsGreaterThanOrEqualTo, Value = 0
    }
);
groupFilter1.Add(
    new FilterDescriptor()
    {
        PropertyName = "UnitPrice",
        Operator = FilterOperator.IsLessThan, Value = 50
    }
);

CompositeFilterDescriptorCollection groupFilter2 = new CompositeFilterDescriptorCollection();

groupFilter2.LogicalOperator = FilterCompositionLogicalOperator.And;
groupFilter2.Add(
    new FilterDescriptor()
    {
        PropertyName = "UnitsInStock",
        Operator = FilterOperator.IsEqualTo, Value = 0
    }
);

queryDescriptor.FilterDescriptors.LogicalOperator = FilterCompositionLogicalOperator.Or;

queryDescriptor.FilterDescriptors.Add(groupFilter1);
queryDescriptor.FilterDescriptors.Add(groupFilter2);

// paging
// get the record 6 - 10
queryDescriptor.PageDescriptor.PageSize = 5;
queryDescriptor.PageDescriptor.PageIndex = 1;

// sorting
// sort by category ascending then by product id descending
queryDescriptor.SortDescriptors.Add(
    new SortDescriptor()
    {
        PropertyName = "CategoryID",
        Direction = System.ComponentModel.ListSortDirection.Ascending
    }
);
queryDescriptor.SortDescriptors.Add(
    new SortDescriptor()
    {
        PropertyName = "ProductID",
        Direction = System.ComponentModel.ListSortDirection.Descending
    }
);    

Remarks

The SortDescriptors is a property that contains a collection of SortDescriptor that hold sorting information.

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2012 All Rights Reserved.