Adding Pagination using data pager to data grid Silverlight 3

Question

 Hi,

I am new to silverlight 3 and trying to attach pagination using data pager. i have written the following code but its not working.. i am calling the data from WCF

Service

 

 

<StackPanel x:Name="LayoutRoot" Background="White">
        <data:DataGrid x:Name="TempDataGrid" AutoGenerateColumns="False" >
        	<data:DataGrid.Columns>
        		<data:DataGridTextColumn Header="Name" Binding="{Binding Name}"  />
        		<data:DataGridTextColumn Header="Score" Binding="{Binding Score}" />
        		<data:DataGridTextColumn Header="Status" Binding="{Binding Status}" />
        	</data:DataGrid.Columns>
        </data:DataGrid>
        <data:DataPager x:Name="TempDataGridDataGridPager" HorizontalAlignment="Left" VerticalAlignment="Top" DisplayMode="FirstLastPreviousNext" PageSize="5" 
                        Source="{Binding Path=ItemSource,ElementName=TempDataGridDataGrid}">
        </data:DataPager>
    </StackPanel>

and in the code behind i am getting the whole list of 100 records in e.result

 
TempDataGrid.ItemsSource = e.Result;
  

  

Answer 1

 Hello,

         see this link 

         http://silverlight.net/learn/tutorials/sqldatagrid.aspx

 

Mark as answer if it helpful to u.........

Thanks,

Pratixa

Answer 2

Hi,

Check this out. This may help you out-

http://msdn.microsoft.com/en-us/magazine/dd695920.aspx
http://stackoverflow.com/questions/1143155/domaindatasource-datapager-with-silverlight-3-datagrid-net-ria-services

Thanks,

Pravin

"Please mark as answered, if this answers your question"

Answer 3

 Hello,

        see this link also..... It is using the RIA Controls

        http://msmvps.com/blogs/theproblemsolver/archive/2009/04/27/paging-with-the-silverlight-ria-services-domaindatasource.aspx

 

Mark as answer if it helpful to u....

Thanks,

Pratixa

Answer 4

 

its really good

Answer 5

 Hello,

Thanks to all  for your replies.. But Why is it necessary to use RIA services controls to implement pagination.

Can't I do pagination without RIA services and just using simply silverlight controls.

 

Thanks,

Kalashnikov

Answer 6

 Hello,

         I think you ahve problem in your code

       

        <data:DataPager x:Name="TempDataGridDataGridPager" HorizontalAlignment="Left" VerticalAlignment="Top" DisplayMode="FirstLastPreviousNext" PageSize="5" 
                        Source="{Binding Path=ItemSource,ElementName=TempDataGridDataGrid}">
        </data:DataPager>

         You have taken the  - ElementName=TempDataGridDataGrid, but u have to take the 
              ElementName=TempDataGrid

Mark as Answer if it helpful to u...

Thanks,

Pratixa 

 

Answer 7

Hi,

Just solved this problem. Check this post and It may help you out-

http://silverlight.net/forums/t/122632.aspx

Thanks,

Pravin

"Please mark as answered, if this answers your question"

Answer 8

 Hello,

Found a simple solution for doing it. We can bind the list obtained from the WCF service to the PagedCollectionView and use it in the ItemsSource of the data grid and Source of the Data Pager.

here is the code,

 

<data:DataGrid x:Name="TempDataGrid"   />
<data:DataPager x:Name="TempDataGridPager" 
Source="{Binding Path=ItemsSource,ElementName=TempDataGrid}"
PageSize="5"/>

and code behind

PagedCollectionView tempListView = new PagedCollectionView(e.Result);
TempDataGrid.ItemsSource = tempListView ; 

  

 where e.Result is the list of objects returned from the WCF service .

Thanks everyone for your help !!

 

Regards,

Kalashnikov

 

Answer 9

Hi,

That's good. Please mark it as answered !!

Thanks,

Pravin

"Please mark it as answered, if this answers your question"

Answer 10

hi

plz ask me How to insert a row and edit it a datagrid in ria service in silverlight 3

i try to add a row with a child window but i want to click add button to add a new row in datagrid

plz ask in ria service without binding plz

Answer 11

hi

plz ask me How to insert a row and edit it a datagrid in ria service in silverlight 3

i try to add a row with a child window but i want to click add button to add a new row in datagrid

plz ask in ria service without binding plz

Answer 12

Dumb questions but......I can't seem to find any interface or classes with PagedCollectionView

 How can I use it?

:(

Answer 13

neverming...I had to add reference to the project. For some reason, using "using System.Windows.Data" wasn't enough.

 

Answer 14

Guys,

I have a DataPager under a grid, that it is not linked with the grid (I will get records at the SQL when user click to next page of the DataPager).

The total of registers returned of SQL is always 10(because pagination of SQL the total of records returned each time is 10). Therefore ItemSource of the grid have always only 10 lines..

I get the total of records with "Select Count...) 

How to put total of pages at DataPager?

Thanks in advance.

 

Loas

 

 

Answer 15

Loas, even I am stuck with the same problem. Any solution is appreciated.

Answer 16

Thanks you so much.

Answer 17

It's simple. You just need to know the total records count. Get this from  your datapager and minus eg :

Protected Sub ListView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListView1.DataBound
        Dim item As ListViewDataItem
        For Each item In ListView1.Items

            Dim lbl As Label = CType(item.FindControl("Label1"), Label)
            lbl.Text = (myDataPager.TotalRowCount /10)+"" //total of pages
        Next

...

Answer 18

PagedCollectionView tempListView = new PagedCollectionView(e.Result);
TempDataGridPager.Source = tempListView ; 
TempDataGrid.ItemsSource = tempListView ;

I think it looks better now... 

PagedCollectionView Class -> Namespace: System.Windows.Data