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

  • CSS3 Table Border Rounding in Older Versions of the Major Browsers

    Introduction: In the past while I have been playing with CSS3 markup to round my HTML table borders. The latest versions of the major browsers now support CSS3 table border rounding using standardized CSS3 property tags. This means that IE9+, Firefox8+, Chrome5+, Opera10.5+, Safari5+ all support the border-radius: Npx property style. However older versions of…

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