topic Re: DataPager not working when binding to silverlight datagrid with URL ArcGIS servic in ArcGIS API for Silverlight Questions

DataPager not working when binding to silverlight datagrid with URL ArcGIS service!

AnhTruong — Sun, 11 Dec 2011 13:20:27 GMT

Hello,

I searched for paging solution in ArcGIS for Silverlight dataGrid and could not find out the solution???
In my dataPager, I can see how many pages but when I navigate using next, previous the data not display by page size.

Here are my codes as following:

MainPage.xaml

<sdkataPager x:Name="SCHPager" Grid.Column="1" Grid.Row="1" VerticalAlignment="Bottom" Background="#FF333333" Foreground="#FFE5E5E5" BorderBrush="Black" Source ="{Binding Path = ItemsSource, ElementName=QueryDetailsDataGrid}" PageSize="30" />

MainPage.xaml.cs

QueryTask queryTask = new QueryTask("http://egis/ArcGIS/rest/services/SCH/MapServer/0");
queryTask.ExecuteCompleted += QueryTask_ExecuteCompleted;
queryTask.Failed += QueryTask_Failed;

ESRI.ArcGIS.Client.Tasks.Query query = new ESRI.ArcGIS.Client.Tasks.Query();
query.Text = TaskNumberTextBox.Text;
query.OutFields.Add("*");
query.Where = "1=1";
queryTask.ExecuteAsync(query);

QueryDetailsDataGrid.ItemsSource = new PagedCollectionView("http://egis/ArcGIS/rest/services/SCH/MapServer/0");
SCHPager.Source = QueryDetailsDataGrid.ItemsSource;

Anything extra code in my code behind? I am newbie to ArcGIS API for silverlight, so I really need your expertise to make it happen. Thanks in advance.

Re: DataPager not working when binding to silverlight datagrid with URL ArcGIS servic

JenniferNery — Fri, 10 Dec 2021 20:43:52 GMT

To enable paging in your data grid, you need to use PagedCollectionView. You cannot create an instance of PagedCollectionView by passing service url. You need to pass the results of your Query. http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#QueryWithoutMap.

PagedCollectionView pagedCollectionView;
void QueryTask_ExecuteCompleted(object sender, QueryEventArgs args)
{
 pagedCollectionView = new PagedCollectionView(args.FeatureSet);
}

Re: DataPager not working when binding to silverlight datagrid with URL ArcGIS servic

AnhTruong — Thu, 15 Dec 2011 19:30:25 GMT

Here are my detailed code after changes as following:

MainPage.xaml.cs

private void LoadData()
{

QueryTask queryTask = new QueryTask(URLService);
queryTask.ExecuteCompleted += QueryTask_ExecuteCompleted;
queryTask.Failed += QueryTask_Failed;

ESRI.ArcGIS.Client.Tasks.Query query = new ESRI.ArcGIS.Client.Tasks.Query();
query.OutFields.Add("*");
query.Where = "1=1";
queryTask.ExecuteAsync(query);

// How do you make changes for two following lines???
QueryDetailsDataGrid.ItemsSource = new PagedCollectionView("http://egis/ArcGIS/rest/services/SCH/MapServer/0");
SCHPager.Source = QueryDetailsDataGrid.ItemsSource;

}

void QueryTask_ExecuteCompleted(object sender, QueryEventArgs args)
{
FeatureSet featureSet = args.FeatureSet;
pagedCollectionView = new PagedCollectionView(args.FeatureSet);

if (featureSet != null && featureSet.Features.Count > 0)
QueryDetailsDataGrid.ItemsSource = featureSet.Features;
else
MessageBox.Show("No features returned from query");
}

MainPage.xaml

<sdk:DataPager x:Name="SCHPager" Grid.Column="1" Grid.Row="1" Source ="{Binding Path = ItemsSource, ElementName=QueryDetailsDataGrid}" PageSize="30" />

==========================================================================

I added new code to QueryTask_ExecuteCompleted(object sender, QueryEventArgs args) but nothing seems to be working at all. Please double check it. Thanks.

Re: DataPager not working when binding to silverlight datagrid with URL ArcGIS servic

DominiqueBroux — Fri, 10 Dec 2021 20:43:55 GMT

void QueryTask_ExecuteCompleted(object sender, QueryEventArgs args)
{
FeatureSet featureSet = args.FeatureSet;
pagedCollectionView = new PagedCollectionView(args.FeatureSet);

if (featureSet != null && featureSet.Features.Count > 0)
QueryDetailsDataGrid.ItemsSource = featureSet.Features;
else
MessageBox.Show("No features returned from query");
}

should be:

 
void QueryTask_ExecuteCompleted(object sender, QueryEventArgs args)
{
FeatureSet featureSet = args.FeatureSet;
pagedCollectionView = new PagedCollectionView(args.FeatureSet);

if (featureSet != null && featureSet.Features.Count > 0)
QueryDetailsDataGrid.ItemsSource = pagedCollectionView ;
else
MessageBox.Show("No features returned from query");
}

Re: DataPager not working when binding to silverlight datagrid with URL ArcGIS servic

AnhTruong — Fri, 10 Dec 2021 20:43:57 GMT

You're super code. Thanks again.

should be:

 
void QueryTask_ExecuteCompleted(object sender, QueryEventArgs args)
{
FeatureSet featureSet = args.FeatureSet;
pagedCollectionView = new PagedCollectionView(args.FeatureSet);

if (featureSet != null && featureSet.Features.Count > 0)
QueryDetailsDataGrid.ItemsSource = pagedCollectionView ;
else
MessageBox.Show("No features returned from query");
}