Scrolling through large resultsets with Silverlight 2 Beta1 and LINQ to SQL



In this 15 minutes video blog I will show you how you can scroll through large resultsets using the SL DataGrid and LINQ to SQL.



I will show:
 paging server side using .Skip and .Take methods in LINQ to SQL
 templating the DataGrid for adding the paging vertical scrollbar


You should watch first this video blog that teach you the basics how to get data from SQL in to SL:  http://blogs.msdn.com/swiss_dpe_team/archive/2008/03/17/silverlight-2-beta1-wcf-linq-to-sql-a-powerfull-combination.aspx


Attached the sample solution


Have fun


Ronnie Saurenmann


double click the player to play in fullscreen

ScrollingLargeResult.zip

Comments (12)

  1. Apologies for the sparseness of my posting the last few weeks – work and life have been busy here lately

  2. Apologies for the sparseness of my posting the last few weeks – work and life have been busy here lately. 

  3. Apologies for the sparseness of my posting the last few weeks – work and life have been busy here lately

  4. 【原文地址】 May 20th Links: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF 【原文发表日期】 Tuesday

  5. Mijn verontschuldigingen voor de weinige posts de laatste weken. Mijn werk en leven zijn enorm de druk

  6. You might have noticed that posts have dropped off over the last month or so.  The reason being

  7. Mes excuses pour le peu de publications au cours des dernières semaines – le travail et la vie en générale

  8. Attached Properties by Illa Iordanov, Animating ListBox Items by Ivan Dragoev, Programmatic DeepZoom

  9. (以下内容全部整理自博客堂Scottgu博客中文版)Silverlight技巧,诀窍,教程和链接 【原文地址】SilverlightTips,Tricks,…

  10. kobruleht says:

    I tried to compile sample project using Visual Web Developer 2008 Expres with latest SilverLight Tools and with DataGrid Dec 2008 release.

    Build fails with error

    Error 1 The type ‘my:DataGridColumnHeader’ was not found. Verify that you are not missing an assembly reference and that all referenced assemblies have been built. C:scrollinglargeresultSilverlightApplication4SilverlightApplication4Page.xaml 132 12 SilverlightApplication4

    How to fix ?

    Andrus.

  11. kobruleht says:

    scrollinglargeresult.zip contains older version of LinqToSqlClientHelperLinqHelper.cs file.

    Is it OK to replace this file from "SLCRUD updated.zip" file ?

  12. Fallon Massey says:

    I'm having a lot of trouble making this work in SL4 Visual Studio 2010.

    Is it possible that the author could update this project?

    Thanks!