C1DataGrid的排序和过滤

1.在XAML前加入

xmlns:local="clr-namespace:DEMO.Web" 
xmlns:ria="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.DomainServices"

2.由于C1DataGrid不能将从RIA中直接取出的数据进行过滤,因此需要加入C1RiaAdapter控件。

        <c1:C1RiaAdapter x:Name="_adapter" DataGrid="{Binding ElementName=c1DataGrid1}" InteractionMode="Prompt">
            <ria:DomainDataSource x:Name="_myDataSource" QueryName="GetT_EMPLOYEEQuery" >
                <ria:DomainDataSource.DomainContext>
                    <local:DSZDBDomainContext/>
                </ria:DomainDataSource.DomainContext>
                <ria:DomainDataSource.SortDescriptors>
                    <ria:SortDescriptor PropertyPath="EMPLOYEE_ID" Direction="Ascending" />
                </ria:DomainDataSource.SortDescriptors>
                <ria:DomainDataSource.FilterDescriptors>
                    <ria:FilterDescriptor PropertyPath="EMPLOYEE_NAME" Operator="StartsWith" Value="" />
                    <ria:FilterDescriptor PropertyPath="EMPLOYEE_SEX" Operator="Contains" Value="" />
                </ria:DomainDataSource.FilterDescriptors>
            </ria:DomainDataSource>
        </c1:C1RiaAdapter>

其中DataGrid="{Binding ElementName=c1DataGrid1}" 为c1DataGrid的名字。
      QueryName="GetT_EMPLOYEEQuery" 为DomainDataSource的查询方法。

3.C1DataGrid控件的代码:

        <c1:C1DataGrid ItemsSource="{Binding Data, ElementName=_adapter}" AutoGenerateColumns="False" Height="140"x:Name="c1DataGrid1" VerticalAlignment="Top" Width="474" ColumnHeaderClickAction="Sort"CanUserFilter="True">
            <c1:C1DataGrid.Columns>
                <c1:DataGridTextColumn Binding="{Binding EMPLOYEE_ID}" SortMemberPath="EMPLOYEE_ID" CanUserResize="False" CanUserSort="True" Header="编号" Width="50" />
                <c1:DataGridTextColumn Binding="{Binding EMPLOYEE_NAME}" SortMemberPath="EMPLOYEE_NAME"  CanUserResize="True" CanUserSort="True" Header="姓名" Width="150"FilterMemberPath="EMPLOYEE_NAME"/>
                <c1:DataGridTextColumn Binding="{Binding EMPLOYEE_SEX}"  SortMemberPath="EMPLOYEE_SEX" CanUserResize="True" CanUserSort="True" Header="性别" Width="40"FilterMemberPath="EMPLOYEE_SEX"/>
            </c1:C1DataGrid.Columns>
        </c1:C1DataGrid>

 

  

 

 

转载于:https://www.cnblogs.com/ajeeky/archive/2012/09/04/2671141.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值