how can user choose which data he want to view in gridview
<p>I have a gridview that contains 100 of rows I want that user can select how many rows in the grid he want to view (Means header and data of that header). Have you any idea. 
Example:</p>

<pre><code>SL     NO       NAME     DATE       END DATE           SUB TOTAL             TOTAL 
==================================================================================


==================================================================================
</code></pre>

<p>User can choose he want to see only  SL NAME SUB TOTAL TOTAL in gridview and after that Grid will display data like this</p>

<pre><code>SL            NAME                   SUB TOTAL                          TOTAL
==============================================================================



==============================================================================
</code></pre>

<p>I am binding like this</p>

<pre><code>&lt;data:ActiveOrdersDataSource ID="ActiveOrdersDataSourcebyCompany" runat="server" SelectMethod="GetPaged" EnablePaging="True" EnableSorting="True" EnableDeepLoad="True"&gt;
    &lt;DeepLoadProperties Method="IncludeChildren" Recursive="False"&gt;
        &lt;Types&gt;
            &lt;data:ActiveOrdersProperty Name="Clients" /&gt;
            &lt;data:ActiveOrdersProperty Name="Companies" /&gt;
            &lt;data:ActiveOrdersProperty Name="Drivers" /&gt;
            &lt;data:ActiveOrdersProperty Name="SalesPeople" /&gt;
            &lt;data:ActiveOrdersProperty Name="ServiceTypes" /&gt;
            &lt;data:ActiveOrdersProperty Name="VehicleTypes" /&gt;
            &lt;data:ActiveOrdersProperty Name="Zones" /&gt;
        &lt;/Types&gt;
    &lt;/DeepLoadProperties&gt;
    &lt;Parameters&gt;
        &lt;asp:SessionParameter Name="CompanyId" SessionField="CompanyId" Type="String" /&gt;
        &lt;data:SqlParameter Name="WhereClause" UseParameterizedFilters ="false"&gt;
            &lt;Filters&gt;
                &lt;data:ActiveOrdersFilter Column="CompanyId" ControlID="ddlCompany" PropertyName="SelectedValue" ComparisionType="Equals" /&gt;
                &lt;data:ActiveOrdersFilter Column="AccountNumber" ControlID="ddlAccount" PropertyName="SelectedValue" ComparisionType="Equals" /&gt;
                &lt;data:ActiveOrdersFilter Column="ServiceTypeId" ControlID="ddlService" PropertyName="SelectedValue" ComparisionType="Equals" /&gt;
                &lt;data:ActiveOrdersFilter Column="VehicleTypeId" ControlID="ddlVehicle" PropertyName="SelectedValue" ComparisionType="Equals" /&gt;
                &lt;data:ActiveOrdersFilter Column="StatusId" ControlID="ddlStatus" PropertyName="SelectedValue" ComparisionType="Equals" /&gt;
                &lt;data:ActiveOrdersFilter Column="OrderNo" ControlID="txtOrderNumber" ComparisionType="Contains" /&gt;
            &lt;/Filters&gt;
        &lt;/data:SqlParameter&gt; 
    &lt;/Parameters&gt;
&lt;/data:ActiveOrdersDataSource&gt;
</code></pre>
