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
double click the player to play in fullscreen
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
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 ?
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?