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

  • CSS3 Table Border Rounding for Modern Browsers (IE9+, Firefox, Chrome5+)

    Background: Lately I have been playing around with HTML5 and CSS3 while building a Web Site UI for a corporate Intranet. I am guaranteed that users will be using IE, so I am happily able to tailor my code directly for IE 9. The caveat to using CSS3 rounded borders in IE is that they…

  • VB.NET Type Conversion (Casting) Overview

    VB.NET supports several type conversion functions. Widening conversions are handled by the compiler and don’t need to be explicitly written, but narrowing conversions require use of VB.NET’s type conversion functions. The three type conversion functions are: DirectCast CType (and CInt, CStr,…Cxxx) TryCast The compiler may not report an error if you code a narrowing conversion…

  • SQL Server: How to Ad-Hoc Query an Excel Spreadsheet using OpenRowset

    Running an ad-hoc query from SQL Server SSMS to an Excel spreadsheet is amazingly straightforward using the OpenRowset command. Here’s how it’s done… For starters, copy the Excel spreadsheet to a location where the installed version of SQL Server can access it. This is necessary since your query in SSMS (SQL Server Management Studio) will…