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.

Author: Justin Cooney

  • 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…

  • Notes on Securing your Web Application Database Calls (Part 1)

    A common part of writing a Web-based application in any programming  language is setting up a SQL query and adding parameters to it. Although most of us have been doing this in one form or another for many years now, there are serious consequences involved that every developer should be aware of. I’m planning this…

  • ASP.NET – Generating an Excel Report on the Fly Using the Interop.Excel Namespace

    As a developer, a commonly requested feature is the ability to export data from the Web into MS Excel. Choosing the best way to export your data from an ASP.NET Web page to Excel for your users is never an easy task. There are several ways to generate your reports, with each way having its pros…