Converting ASP.Net 1.1 style CodeBehinds to 2.0 style partial classes

Posted by: on | Wednesday, March 21, 2007     Comments

I am guessing a lot of people out there are like me and have projects that they started working on in ASP.Net 1.1, and later migrated to 2.0. This blog is about how to move your old files into the brave new world...

One of the neat features with web forms created from scratch in 2.0 is the separation of the Code Behind files into two partial classes: one partial class in a file called formname.aspx.designer.cs, and one in formname.aspx.cs. The designer file is autogenerated and contains declarations of all the form level variables, for instance if you drop a TextBox ...

T-SQL: Creating Dynamic Pass-Through Queries For Use With OPENQUERY

Posted by: on | Thursday, March 15, 2007     Comments

When querying an external data source through a linked server, you have two choices: you can write a typical T-SQL query, specifying the external tables with their four-part name in the FROM clause, or use the OPENQUERY function. The first option has advantages, as long as the external provider supports enough SQL so that SQL Server can take your query and translate it into a query that the external data source can use. On the other hand, if th external provider doesn't support enough SQL for SQL Server to optimize the query, or if the external provider is just too ...

Working with hierarchical datatables

Posted by: on | Wednesday, March 14, 2007     Comments

Today I battled with some interesting problems writing changes to a hierarchical datatable to a SQL Server database. Hopefully by writing about this I can save you some time.

To reduce the problem to its bare bones, I had a datatable that is a self-referencing hierarchy. The tree can have multiple roots. Each record has an ID, a nullable ParentID and some data fields. Any record with a ParentID of null is a root. In this real world app there are some additional details, for instance each record can have leaf node children in another table, but I will leave ...

Get public key token for an assembly

Posted by: on | Tuesday, March 13, 2007     Comments

You may need the public key token for purposes such as registering an HTTP module.  Use the strong naming tool with the -T option to extract the public key.  Be sure to call sn from the command line that comes with the .NET framework SDK:

C:\Program Files\telerik\r.a.d.controlsQ4 2006\NET2\bin>sn -T radupload.net2.dll

Microsoft (R) .NET Framework Strong Name Utility  Version 2.0.50727.42
Copyright (c) Microsoft Corporation.  All rights reserved.

Public key token is b4e93c26a31a21f0


SQL Server 2005 SP2 rereleased!

Posted by: on | Tuesday, March 06, 2007     Comments

There was a bug in SP2 regarding maintenance plans, see official note below:

An issue was recently discovered with SQL Server 2005 SP2 which might impact customers using cleanup tasks in Maintenance Plans and SQL Server Integration Services packages. The issue is described in detail at http://support.microsoft.com/kb/933508. We have created a General Distribution Release (GDR) #50000939 to address this issue which is available for download and we have included the GDR in a refresh of the SP2 installation package

More information can be found here.

Implementing the ITemplate Interface

Posted by: on | Friday, March 02, 2007     Comments

I was doing some work the other day, and found that I had the need to implement a template programatically (rather than creating it at design time). I love the internet search engines, and the (sometimes overwhelming) amount of information you can usually find on any subject, but there wasn't a whole lot on this subject. To make matters worse, the articles I did find hinted around the edges of what I was looking for, but none seemed to describe what I needed to do very closely - they all addressed the aspect of the problem that they were interested ...