Is there a way to determine in which page of a paginated grid a record is?

[Silvio]

Hi,

I have a paginated SfDataGrid binded to a collection of records using SfDataPager.

I'd like, at runtime (by code), to move to a particular page where a particular record is displayed.

Is there a method to determine by code in which page number a particular record is actually displayed ?

[Saravanan Ayyanar]

Hi Silvio, 

 

Thank you for using Syncfusion controls. 

 

We have checked your reported scenario. You can achieve your requirement by getting the PagedCollectionView.InternalList. Using this internal list you can calculate the PageIndex using SfDataPager.PageSize property.  It working same as for while sorting the SfDataGrid. Please refer the below code snippet. 

 

private void Button_Click(object sender, RoutedEventArgs e) 

{ 

    var collection = (this.dataGrid.View as PagedCollectionView).GetInternalList(); 

    int i = 0; 

    foreach (var rec in collection) 

    { 

        var value = (rec as OrderInfo).OrderID; 

 

        if ((int)value == 1019) 

        { 

            int index = i / this.sfDataPager.PageSize; 

            this.sfDataPager.PageIndex = index; 

            this.dataGrid.SelectedIndex = i % this.sfDataPager.PageSize; 

            var rowindex = this.dataGrid.ResolveToRowIndex(this.dataGrid.SelectedIndex); 

            var visualcontainer = this.dataGrid.GetVisualContainer(); 

            visualcontainer.ScrollRows.ScrollInView(rowindex); 

            break; 

        } 

        i++; 

    } 

} 

 

Sample Link: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/DataPagerSample-1142073532 

 

Please let us know, if you require further assistance on this. 

 

Regards, 

Saravanan A.