Getting a “pure” date in MS SQL (without the time)

You probably know the situation: You want to get all records grouped by day, but you stored their creation date using getdate(), so now they all contain time as well as the date.

The solution until MS SQL 2008 was not pretty, however with MS SQL 2008 we finally have a “pure” date datatype.

Read More »

Serverside paging with Ms SQL 2005 / 2008

If you’ve done any amount of website development, you know the issues with paging your data.

With MS SQL 2005 and newer there’s an easy way to do it in your SQL queries. And it even performs better to boot!

Here I’ll sum up how to write proper paging queries with superb performance.

Read More »

Accessing session in HttpHandlers

In ASP.Net HttpHandlers cannot access the session state by default, in order to enable them to do so, you need to implement an interface.

However this is rather simple, since the interface is just a “marker interface” as MSDN calls it. Here’s how to do it.

Read More »

“Var” keywordet, godt eller skidt ?

Var keywordet i C# har alle efterhånden en mening om, og typisk er billedet meget sort/hvidt.
Så for at deltage lidt i “festen”, følger her min mening om var.

Men inden da er her lige en forklaring på var keywordet, til dem der ikke kender det.

Var bruges istedet for en type, når man deklarerer variable.

Read More »

C# Yield, hvad kan den

Yield har været med helt fra .Net 2.0 – alligevel bruges den ret sjældent.
Men hvad kan yield egentlig ?
Den kan bl.a. give en væsentligt pænere syntax i visse metoder.

Read More »