MSDN Blog Schweiz

Aktuelle Microsoft-News, Anleitungen, Downloads, Tools und Veranstaltungen für Schweizer Entwickler.

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

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

  • Comments 12

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

Attachment: ScrollingLargeResult.zip
  • Apologies for the sparseness of my posting the last few weeks - work and life have been busy here lately

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

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

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

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

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

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

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

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

  • 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:\scrollinglargeresult\SilverlightApplication4\SilverlightApplication4\Page.xaml 132 12 SilverlightApplication4

    How to fix ?

    Andrus.

  • scrollinglargeresult.zip contains older version of LinqToSqlClientHelper\LinqHelper.cs file.

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

  • 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!

Page 1 of 1 (12 items)
Leave a Comment
  • Please add 3 and 8 and type the answer here:
  • Post