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.lire la suite
Sur le même thème :
- Creating Localization Tool with Silverlight
Since Silverlight 2 is in Beta 2 phase it’s definately time to create small application with it. Together with my friend we’e created small example application called Localization Tool. Idea in our example application is pretty simple... allow end users to modify texts used in application. And for the end user it should be easy, intuitive and of course fast. We used a lot of information available from internet in order to help us in the implementation (see links at the end of this post).
- Silverlight 2 - Mini-Geburtstagsverwaltung
Eine meine Lieblingsdemos ist immer das Erstellen eines Mini-CRM-Systems. Daran kann man prima zeigen, wie leicht es ist aus Silverlight heraus Daten in eine Datenbank zu schreiben und von dort wieder auszulesen. Das ganze mittels Webservicezugriff, LINQ, SQL Server uvm.. Diese kleine Geburtstagsverwaltung habe ich in Form eines Channel 9 Videos auch direkt kommentiert. Das Video wird in Kurze hier ebenfalls veroffentlicht.
- 惱人的 SQL Injection
這一兩個月來真的是風風雨雨,到這禮拜還是有客戶遭受攻擊。 回想早在 2002 年台灣微軟就投入許多資源宣導預防 SQL Injection,過了 6 年還是常常災情不斷。 好的軟體專案除了滿足功能性需求外,也不要忽略諸如安全性的非安全性需求啊! 苦命的程式設計師們,如果你還沒聽過 SQL Injection,請快拜讀胡百敬先生寫的這兩篇文章,看看你寫的程式會如何被攻擊 .
- 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.
- CRUD operations with Optimistic Locking using Silverlight 2 Beta1, WCF and LINQ to SQL (inserts, updates and deletes)
In this 30 minutes video blog I will show you one approach on how to do insert, update and delete operations with optimistic locking in a 3 tier environment. As you may know LINQ to SQL do not offer client side change tracking out of the box so you need to implement your own. I will also show a master detail example. To keep things simple I tried to mimic the behavior of DataSet treating every entity (e.
- 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. Below is a new post in my link-listing series to help kick things up a little. Also check out my ASP.NET Tips, Tricks and Tutorials page and Silverlight Tutorials page for links to popular articles I've done myself in the past. ASP.NET · Bulk Inserting Data with the ListView Control.
- LINQ to SQL - Usando chave composta
Estou de volta das minhas tão esperadas ferias. Depois de dois anos e muito bom poder descansar um pouco. Durante as ferias tive tempo para responder alguns emails que havia recebido com dúvidas após o TechEd. Uma das dúvidas bem interessantes que recebi foi sobre o uso de chave composta com o LINQ to SQL. A pessoa queria saber se era possível utilizar tabelas com chave compostas para o mapeamento no LINQ to SQL e depois criar o relacionamento ente objetos.
- LINQ To SQL Delay Loaded et serialization bug
LINQ To SQL Delay Loaded et serialization bug Je viens de m'apercevoir d'un "bug" avec LINQ To SQL. J'ai une table (au sens LINQ To SQL) avec une propriete Delay Loaded (c'est a dire que le champ prive n'est pas de type T mais de type System.Data.Linq.Link). Lorsque je veux requeter ma table et envoyer le resultat via un webservice, j'ai une exception System.InvalidOperationException.
- LINQ To SQL, l'integration des nouveaux types de SQL Server 2008 pour bientot :-)
LINQ To SQL, l'integration des nouveaux types de SQL Server 2008 pour bientot :-) Faisal Mohamood vient d'annoncer le support des nouveaux types de SQL Server 2008 : DATE, TIME, DATETIME2 et DATETIMEOFFSET avec LINQ To SQL (pour plus d'info sur SQL Server 2008, voir le blog de Christian ou de Pascal). Posted: vendredi 22 fevrier 2008 07:03 par Matthieu MEZIL Classe sous .
- Support for SQL 2008 Data Types Coming into LINQ to SQL
Check it out, on the ADO.NET Team blog Faisal Mohamood, a PM on the LINQ to SQL team, posted on the new features you can expect to see added to LINQ to SQL. This includes support for new data types coming in SQL 2008. Enjoy!
Les blogs qui parlent de :
- ">Have
- //silverlight services
- Calibri
- Times
- ascii
- blogs
- character
- class=MsoNormal
- combination
- family
- powerfull combination
- style="FONT
- style="mso
- templating DataGrid