Extending the SqlDataAdapter with a FillTimeout

The SqlDataAdapter has a CommandTimeout property but does offer any method to set any kind of timeout during the Fill method. If you are returning rather large data sets, you can quickly run into a problem. The obvious solution would be to inherit the SqlDataAdapter and simply override the Fill method, except that the SqlDataAdapter cannot be inherited. As a result, we must implement the same methods that the SqlDataAdapter does and attach them to a private internal SqlDataAdapter to do all the heavy lifting. With the use of anonymous delegates, we can easily rework the Fill methods to offer a new FillTimeout property and throw an exception when we exceed our desired timeout.

Continue reading “Extending the SqlDataAdapter with a FillTimeout”

Improved ASP JSON utility

Most of the projects that I have been working on lately did not require any advanced AJAX. Most of the time, stuffing the results of a simple GET into innerHTML has usually been sufficient. Recently, I needed to do some more advanced AJAX work so I started looking into JSON. There a hundreds of helper classes that people have dreamed up already for ASP.NET, however this project was under the Classic ASP (VBScript) umbrella.

I fell upon a nice little utility on aptly called aspjson. It is a nice utility except the implementation of multi-dimensional array support is flawed. Try to JSON an array that has dimensions with more than 10 elements and you will quickly see what I mean.

I rewrote the multi-dimensional array support from scratch and I am releasing the code under the same license as the original author as well as obviously attributing credit to Tuğrul Topuz for his original code.

Download the ASPJSON 2.1 source

Fixing Dreamweaver CS4’s JavaScript Events for XHTML

One of the first things you learn about XHTML is lowercase. Everything is lowercase. Lowercase tags, lowercase attributes, lowercase, lowercase, lowercase…

I guess it wasn’t obvious enough to the developers over at Adobe because Dreamweaver CS4 has this annoying habit of mix-casing all of the JavaScript event handlers.

Continue reading “Fixing Dreamweaver CS4’s JavaScript Events for XHTML”