Display total row count and current row indexes

290

Frank Stegerwald posted over 14 years ago

Hi,

I have a WebDataGrid 10.2 with paging enabled and I want to display something like that: "Row 10 to 20 of 500 rows".

I tried to do it in code behind but I do not get a postback on PageIndexChanged. Additionally I don't know where to get the total row count. In the moment I get this info from data source but I want to display the "filtered" row count. That means if someone applies a filter I want to display the rows which are not filtered out.

Any ideas?

Parents

12679

[Infragistics] Radoslav Minchev posted over 14 years ago

Hello,

Maybe you woud be able to use a custome Paging template :

https://ko.infragistics.com/help/aspnet/webdatagrid-using-custom-paging-template-in-code

Hope this helps.
Cancel
Reply

Cancel

Reply

290

Offline Frank Stegerwald posted over 14 years ago in reply to [Infragistics] Radoslav Minchev

Hallo Radoslav Minchev,

that's not realy the anwer that I want. In other words: I need the following WebDataGrid client side Propertys:

TotalRowCount (All rows which are not filtered out)
CurrentPageIndex
RowsOnCurrentPage
Cancel
Reply

Cancel

Children

12679

[Infragistics] Radoslav Minchev posted over 14 years ago in reply to Frank Stegerwald
Hello stegerwald,

I’ve build a sample that shows how can be implemented filtering scenario in combination with paging. In more details : When the grid is filtered and paging has been applied the respective row count is transferred to the client and written to the footer:

ASPX page :

   <ig:WebDataGrid ID="WebDataGrid1" runat="server" Height="350px" Width="759px">
    <ClientEvents AJAXResponse="AJAXResponseHandler" />
        <Behaviors>
            <ig:Filtering>
            </ig:Filtering>
            <ig:Paging QuickPages="2">
            </ig:Paging>
        </Behaviors>
    </ig:WebDataGrid>

    <script type="text/javascript">

        function AJAXResponseHandler(sender, args) {
            var filteredRowsObject  = args.get_gridResponseObject().AdditionalProperties;
            var footer = sender.get_columns().get_column(1).get_footer().get_element();
            footer.innerText = "Filtered Rows : " +filteredRowsObject.rowCount
        }

    </script>

Code behind :

protected void Page_Load(object sender, EventArgs e)
    {
        //Show the footer
        WebDataGrid1.ShowFooter = true;
        WebDataGrid1.DataSource = MakeTable();

        //Register Filtering events
        WebDataGrid1.Behaviors.Filtering.DataFiltering +=
            new Infragistics.Web.UI.GridControls.DataFilteringHandler(Filtering_DataFiltering);

        WebDataGrid1.Behaviors.Filtering.DataFiltered +=
        new Infragistics.Web.UI.GridControls.DataFilteredHandler(Filtering_DataFiltered);

    }

    void Filtering_DataFiltering(object sender, Infragistics.Web.UI.GridControls.FilteringEventArgs e)
    {
         //Remove Paging behavior
        ((WebDataGrid)sender).Behaviors.Remove(this.WebDataGrid1.Behaviors.Paging);
    }
    //This property will be transferred to the client
    int filteredRowsCount = 0;

    void Filtering_DataFiltered(object sender, Infragistics.Web.UI.GridControls.FilteredEventArgs e)
    {
        //Once the filtering has been done we can get the real rows count
        filteredRowsCount = ((WebDataGrid)sender).Rows.Count;
        ((WebDataGrid)sender).GridResponse.AdditionalProperties.Add("rowCount", filteredRowsCount);

        //Return the paging behavior
        ((WebDataGrid)sender).Behaviors.CreateBehavior<Paging>();
    }

The result :

Hope this helps.
Cancel
Reply

Cancel