过滤 - Excel样式.....它的工作bt未选中复选框请查找.. [英] Filtering - Excel Style.....its working bt not checked in check box please find..

查看:74
本文介绍了过滤 - Excel样式.....它的工作bt未选中复选框请查找..的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

此示例演示如何在WebDataGrid控件上启用Excel样式过滤。 Excel样式过滤为用户提供了从具有不同列值的复选框列表中选择搜索条件的选项。您可以选择列表项的子集或所有项。在触摸设备上,命中目标被渲染得更大以启用触摸交互,并且网格可以利用轻弹手势来快速滚动其内容。注意:地址列上禁用了筛选。

.......

--------------------------- -------------------------------------------------- -----------

 <   body  >  
< 表单 id = form1 runat < span class =code-keyword> = server >

< div id = gridContainer style = 溢出:可见 >
< ig:WebDataGrid ID = WebDataGrid1 runat = server AutoGenerateColumns = 错误 DataSourceID = SqlDataSource1

宽度 = 100% 高度 = 425px DataKeyFields < span class =code-keyword> = proj_id >
< >

< ig: BoundDataField DataFieldName = proj_id = proj_id >
< 标题 文字 = proj_code / >
< / ig:BoundDataField >
< ig:BoundD ataField DataFieldName = proj_code = proj_code >
< 标题 文字 = proj_name / >
< / ig:BoundDataField >
< ig:BoundDat aField DataFieldName = proj_name = proj_name >
< 标题 文字 = proj_desc / >
< / ig:BoundDataField >
< /列 >
< EditorProviders >
< ig:TextBoxProvider ID = TextBoxProvider / >
< / EditorProviders >
< 行为 >
< ig:过滤 < span class =code-attribute> 对齐 = 顶部 可见性 = 可见 已启用 = true FilterType = ExcelStyleFilter >
< ColumnSettings >
< span class =code-keyword>< ig:ColumnFilteringSetting ColumnKey = proj_code 已启用 = true / >
< / ColumnSettings >
< / ig:过滤 >
< span class =code-keyword><
/行为 >

< / ig:WebDataGrid > ;
< / div >

< < span class =code-leadattribute> asp:ScriptManager ID = ScriptManager1 runat = server >
< / asp:ScriptManager >
< asp:SqlDataSource ID = SqlDataSource1 runat = server ConnectionString = <% $ ConnectionStrings:vpay_dbConnectionString6 %> OnInit = DataSourceInit



SelectCommand = SELECT [proj_id],[proj_code],[proj_name],[proj_desc] FROM [Project] > < / asp:SqlDataSource >





< / form >
< / body >

解决方案

ConnectionStrings:vpay_dbConnectionString6 %> OnInit = DataSourceInit



SelectCommand = SELECT [proj_id],[proj_code],[proj_name],[proj_desc] FROM [项目] > < / asp:SqlDataSource >





< / form >
< / body >


This sample demonstrates how to enable Excel-style filtering on the WebDataGrid control. Excel-style filtering gives users the option to select the search condition from a checkbox list with distinct values for the column. You can choose a subset of the list items or all items. On touch devices, hit targets are rendered larger to enable touch interactions and the grid can take advantage of the flick gesture to quickly scroll its contents. Note: Filtering is disabled on the Address column.
.......
----------------------------------------------------------------------------------------

<body>
    <form id="form1" runat="server">

 <div id="gridContainer" style="overflow:visible">
    <ig:WebDataGrid ID="WebDataGrid1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"

        Width="100%" Height="425px" DataKeyFields="proj_id">
        <Columns>

            <ig:BoundDataField DataFieldName="proj_id" Key="proj_id">
                <Header Text="proj_code" />
            </ig:BoundDataField>
            <ig:BoundDataField DataFieldName="proj_code" Key="proj_code">
                <Header Text="proj_name" />
            </ig:BoundDataField>
            <ig:BoundDataField DataFieldName="proj_name" Key="proj_name">
                <Header Text="proj_desc" />
            </ig:BoundDataField>
        </Columns>
        <EditorProviders>
            <ig:TextBoxProvider ID="TextBoxProvider" />
        </EditorProviders>
       <Behaviors>
            <ig:Filtering Alignment="Top" Visibility="Visible" Enabled="true" FilterType="ExcelStyleFilter">
                <ColumnSettings>
                    <ig:ColumnFilteringSetting ColumnKey="proj_code" Enabled="true" />
                </ColumnSettings>
            </ig:Filtering>
        </Behaviors>

    </ig:WebDataGrid>
    </div>

      <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:vpay_dbConnectionString6 %>" OnInit="DataSourceInit"



             SelectCommand="SELECT [proj_id], [proj_code], [proj_name], [proj_desc] FROM [Project]"></asp:SqlDataSource>





    </form>
</body>

解决方案

ConnectionStrings:vpay_dbConnectionString6 %>" OnInit="DataSourceInit" SelectCommand="SELECT [proj_id], [proj_code], [proj_name], [proj_desc] FROM [Project]"></asp:SqlDataSource> </form> </body>


这篇关于过滤 - Excel样式.....它的工作bt未选中复选框请查找..的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆