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

  • SQL OpenRowSet Excel Query Returns Null Values

    In an earlier article I reviewed how to query an Excel spreadsheet from SQL Server Management Studio (SSMS). I’ve found that this functionality is very useful, especially when working with data maintained by business users outside of a database system. For an overview of how to connect SSMS with an Excel WorkSheet, please see my detailed article covering…

  • Pinging Services for WordPress Bloggers

    I’ve heard about how pinging services can help to promote new content on one’s Web site. Basically a pinging service works by notifying a list of search providers when you post new content to your Web site or blog. My question is: Do these work and are they needed for a WordPress.com blog? While researching the issue I’ve…

  • Create and Style an Editable Select List Using a JQuery Combobox

    JQuery Combobox By default there is no HTML control that can act as both a dropdown list and an editable input area. The best resource to create such a control is the JQuery Combobox widget. Overview HTML and Web-based controls can cause confusion for users who are accustomed to using Windows applications. Often the look…