(Jeff Levinson) In the first installment of this series, I worked through some of the basic structure of the TfsWorkItemTracking database. I’ll continue with this examination in this column and provide some helpful SQL statements to get you started.
Tag: Development
Loading Double-Clicked Documents into a Single Instance VB.Net Application
(Mike McIntyre) How can documents configured to open with a VB.NET Win Forms application (VB.NET 2005 and newer) – when double-clicked – be opened by a single instance of the application?
Efficient Server Side Paging with the ASP.NET GridView Control
(Malcolm Sheridan) When people talk about paging with the GridView control, they’re normally talking about the default, out of the box, vanilla paging that comes built in the GridView control. This is good for demos or small databases. But what happens to the performance of your website if you conne
An Extensive Examination of LINQ: Lambda Expressions and Anonymous Types
(Scott Mitchell) The previous installment in this article series, Extension Methods, Implicitly Typed Variables, and Object Initializers, examined three new features to the C# 3.0 and Visual Basic 9 languages that allow for developers to use LINQ’s standard query operators and providers to write SQL
How .NET Regular Expressions Really Work
(Jeff Moser) Remember when you first tried to parse text?
Silverlight/WPF FlipImage Animation
(Tess Ferrandez) I was working on some Silverlight samples and needed an image that could flip over as in the example below.
Creating Flexible Constant Fields
(Jay Miller) It is very easy to add constant fields to your classes. All you need to do is add the const keyword to the declaration and set the value. You now have a field whose value cannot change during the execution of your program. Here is an example of using const:
Select top n rows from a table for each group
(Misbah Arefin) We have a retail shop online and with just 2 weeks of our website launch we already have close to 30 orders. Now of course marketing wanted to get some ads up on the site to derive more orders and one for the reports was to get the top two products from each manufacturer which have t
SQL Cache Dependency with SQL Server, LINQ and ASP.NET 3.5
(Malcolm Sheridan) Whenever I think of performance with ASP.NET, the first thing that comes to mind is caching. Simply put caching is an in memory storage of objects that enables the application to read and write data to memory.
skmExpressionBuilders – A Suite of Custom Expression Builder Classes
(Scott Mitchell) An ASP.NET Web control’s properties can be set in one of two ways: declaratively and programmatically. Declaratively setting a Web control’s properties entails specifying the property in the control’s declarative syntax. For example, Web controls have their ID property set declarati
