how to create row number column and pagination

[Sara]

hello

I am trying to implement a Grid View with row number column and pagination.That is, the row number can also be changed when the page is changed

but the code I wrote is that the row number column on each page is only 1 to 10. And by going to the next page the row number starts again from 1 and does not increase to 11 and more.

this is my cs code for row number:

public override FrameworkElement CreateCellElement(Telerik.Windows.Controls.GridView.GridViewCell cell, object dataItem)

        {
            TextBlock textBlock = cell.Content as TextBlock;

            if (textBlock == null)
            {
                textBlock = new TextBlock();
            }
            textBlock.Text = string.Format("{0}", this.DataControl.Items.IndexOf(dataItem) + 1);
            return textBlock;
        }

and xaml code:

<telerik:RadDataPager DisplayMode="all" PageSize="10" Source="{Binding Items, ElementName=RadGridView}"  />

also i need a label that represents the total number of Grid View rows. The value of this label must be updated by applying a filter or searching.

but my code always represents total number of Grid View rows and does not change with filtering.

 

Thanks!

Sara.

[Dinko | Tech Support Engineer]

Hello Sara,

Thank you for the provided code snippet.

The Items collection property represents the current filtered/sorted items in the RadGridView. To get the row number from the collection you can use the ItemsSource instead. For example:

public class CustomGridViewColumn : GridViewDataColumn
{
    public override FrameworkElement CreateCellElement(GridViewCell cell, object dataItem)
    {
        TextBlock textBlock = cell.Content as TextBlock;

        if (textBlock == null)
        {
            textBlock = new TextBlock();
        }
        textBlock.Text = string.Format("{0}", (this.DataControl.ItemsSource as ObservableCollection<MyItem>).IndexOf(dataItem as MyItem) + 1);
        return textBlock;
    }
}

Regarding the total number of gridview rows in filtering and sorting while using RadDataPager. You can create a custom TextBlock and bind its text property to the Items.ItemCount property of the RadGridView.

I have prepared a sample project which demonstrates the above approaches. You can find the project attached to this reply.

Regards,
Dinko
Progress Telerik

[Sara]

Thank's very much, for Response and the sample project.

In sample project, the row number is working correctly.
But when applying the filter or searching, it doesn't work correctly. I want to the row number start at 1 and increase in sequence when applying the row filter.

And also the TextBlock that shows the total number of gridview rows, does not change when the filter is applied. and always is 100.

I want this TextBlock to show the number of rows that are displayed as a result of applying a filter

Thanks,

Sara

 

[Dinko | Tech Support Engineer]

Hello Sara,

Thank you for the provided image.

You are right that after filtering, the row number on a different page is not correct. What you could try is to bind the RadGridView to the PagedSource property of the RadDataPager and the RadDataPager to Data collection. In the CreateCellElement() method, you can set the index depending on the PageIndex property. You can check the modified version of my project attached to this reply.

Regards,
Dinko
Progress Telerik

[Sara]

Thank Dinko for your solution.

it works for me :)

Sara.