Justin Cooney

Web Development Tips and Examples

recent posts

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.

Category: Web Development

  • Configuring a Web Server to Allow Excel File Creation via the Interop.Excel Namespace

    In an earlier article I covered how to generate Excel reports on the fly using the Interop.Excel Namespace. This is a really handy technique that also gives you full control over the minutia of the document you are creating. However the catch in using this technique is that you will need to update the configuration of…

  • ASP.NET Choosing Parameters.Add or Parameters.AddWithValue

    If you are adding parameters to a SqlCommand object then you can use either Parameters.Add or Parameters.AddWithValue. The Parameters.Add syntax requires you to explicitly specify the DataType of the parameter you are passing, while the Parameters.AddWithValue syntax implicitly attempts to convert the parameters you pass in. When choosing which method you want to use, you should be aware that…

  • Regular Expressions in .NET to Surround but not Replace Text Matches

    ASP.NET offers strong support for regular expressions in the System.Text.RegularExpressions Namespace. This is great since regular expressions are essential if you want to do anything beyond basic text manipulations and searches. You can read more about regular expression support in ASP.NET on the official MSDN page. The MSDN site also includes a few good getting…