Welcome to MSDN Blogs Sign in | Join | Help

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

Published Friday, May 09, 2008 2:51 PM by ronnies
Filed under: , ,

Attachment(s): ScrollingLargeResult.zip

Comments

# May 20th Links: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF

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

Wednesday, May 21, 2008 1:03 AM by ScottGu's Blog

# May 20th Links: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF

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

Wednesday, May 21, 2008 1:35 AM by BusinessRx Reading List

# May 20th Links: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF

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

Wednesday, May 21, 2008 1:50 AM by Mirrored Blogs

# 5月20日链接篇: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF

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

Thursday, May 22, 2008 6:19 PM by Joycode@Ab110.com

# Links op 20 mei: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF

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

Saturday, May 24, 2008 3:34 AM by Scott Guthrie's Blog in Dutch

# New Posts Coming Soon...

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

Monday, June 02, 2008 7:08 PM by Scott Morrison

# Liens du 20 mai: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF

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

Tuesday, June 03, 2008 12:41 AM by Scott Guthrie's Blog in French

# Silverlight Cream for June 3, 2008 -- #289

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

Tuesday, June 03, 2008 10:24 AM by Community Blogs

# Silverlight 文章收集

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

Monday, July 21, 2008 10:36 PM by 木野狐(Neil Chen)

# Using with RTM and Dec 2008 DataGrid

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.

Saturday, December 20, 2008 5:19 PM by kobruleht

# LinqToSqlClientHelper\LinqHelper.cs is older than in SLCRUP update.zip file

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

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

Sunday, December 21, 2008 7:29 AM by kobruleht
Anonymous comments are disabled
 
Page view tracker