Justin Cooney

Web Development Tips and Examples

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

SQL Server: T-SQL to Show Table Column Information

2012-12-07

Sometimes using the SSMS GUI table designer is a hassle when compared with directly querying the table structure using a simple SQL statement.

For example if you are right in the middle of editing a stored procedure and want to know the data types and sizes of some columns for a table or two, then rather than navigating away from your procedure, you can do a lookup within the code itself. This saves you a lot of tabbing between windows since the table information is right where you need it; where you are writing your code.

(more…)
Correcting 404 Errors in IIS 6 When Running an ASP.NET ASPX Page

2012-12-06

Register ASP.NET with IIS

I was setting up a new Web Server that had been pre-installed with Windows 2003, IIS 6 and ASP.NET 2.0. The catch was that when I set up a new Web site on the server, I would get a 404 error page when the server was asked to serve up ASP.NET files (aka: files with the .aspx extension). Other files such as standard .html and .asp would render without problems.

I was a bit mystified until I realized that the setup of the pre-installed version of ASP.NET 2.0 on the server likely was done before IIS setup. Thus, although IIS showed ASP.NET 2.0 as an option, ASP.NET wasn’t properly registered with IIS.

At that point all one can do is to either: (more…)
Points to keep in mind when working with the iTextSharp HTML to PDF converter (HTMLWorker)

2012-12-05

If you are looking for a tool to convert an HTML document to a PDF, then the iTextSharp converter is a great tool. iTextSharp provides open source libraries for various languages including Java and .NET. If you wish to commercially use iTextSharp, you will, however, need to pay for the license.

Keep in mind that I am basing my observations on the iTextSharp port to .NET. The Java version may behave differently.

I personally like the iTextSharp tool, and even given its quirks, will continue using it. Please note thatthis article is focussed on observations of the iTextSharp HTMLWorker object. Significant advancements have been made with the iTextSharp XMLWorker object which you can read more about in another article I have written.

Have a look at the collection of articles I’ve written that cover the iTextSharp for .NET PDF generation.

Here are some of the main points to consider when planning/writing your HTML to PDF conversion function using the iTextSharp HTMLWorker Object (more…)

recent posts

about

SQL Server: T-SQL to Show Table Column Information

(more…)

Correcting 404 Errors in IIS 6 When Running an ASP.NET ASPX Page

At that point all one can do is to either: (more…)

Points to keep in mind when working with the iTextSharp HTML to PDF converter (HTMLWorker)

Here are some of the main points to consider when planning/writing your HTML to PDF conversion function using the iTextSharp HTMLWorker Object (more…)