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: Programming

  • Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly

    I’ve been playing around with the ClosedXML.Excel library for creating or reading MS Excel documents in your ASP.NET code. Bottom line is that this tool is going to save you a lot of time: In simplifying your task of putting the Workbook and Worksheets together and I can’t stress enough how much time this will…

  • Handy VBScript to Remove the WhiteSpaces from All File Names in a Folder

    Here is a super simple VBScript that will remove any white spaces from filenames in a folder. There’s no need to specify the folder, just copy it to the folder you need and double click to run it. Of course you’ll have to copy the lines of code below into a notepad file and save it…

  • T-SQL to Enforce Proper Case Capitalization

    This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make…