Freigeben über

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

  • Artikel

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: https://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

  • Anonymous
    May 20, 2008
    Apologies for the sparseness of my posting the last few weeks - work and life have been busy here lately

  • Anonymous
    May 20, 2008
    Apologies for the sparseness of my posting the last few weeks - work and life have been busy here lately. 

  • Anonymous
    May 20, 2008
    Apologies for the sparseness of my posting the last few weeks - work and life have been busy here lately

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

  • Anonymous
    May 23, 2008
    Mijn verontschuldigingen voor de weinige posts de laatste weken. Mijn werk en leven zijn enorm de druk

  • Anonymous
    June 02, 2008
    You might have noticed that posts have dropped off over the last month or so.  The reason being

  • Anonymous
    June 02, 2008
    Mes excuses pour le peu de publications au cours des dernières semaines – le travail et la vie en générale

  • Anonymous
    June 03, 2008
    Attached Properties by Illa Iordanov, Animating ListBox Items by Ivan Dragoev, Programmatic DeepZoom

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

  • Anonymous
    December 20, 2008
    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.

  • Anonymous
    December 20, 2008
    scrollinglargeresult.zip contains older version of LinqToSqlClientHelperLinqHelper.cs file. Is it OK to replace this file from "SLCRUD updated.zip" file ?

  • Anonymous
    September 23, 2010
    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!