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.

  • The Top 3 Free Regular Expression Editors of 2013

    I’ve decided to have a look at what the open-source/shareware market has to offer these days when it comes to text editors that can handle regular expressions.

    I have been using EditPad Lite to test and run my regular expressions, and in the past 10 or so years I have not been able to find any tool that even comes close to being as useful. This time around I tested two other options that have been given good reviews: Notepad++ and PSPad.

    Here are my findings from looking into EditPad Lite, Notepad++, and  PSPad.

    Also if you find this review interesting, I did a review back in 2011 of the top online regular expression testing tools at that time. Feel free to have a look, and let me know what you think!

    (more…)

  • JQuery with ASP.NET: Save Copy / Paste Excel Data to a Database Table

    Have you ever wanted to help your users move data from Excel to your Web application? In this article I will give an example in ASP.NET that takes copied Excel spreadsheet rows from the user’s clipboard and saves the information to a SQL Server database table.

    Since ASP.NET runs at the server level, you will need to use JavaScript/JQuery to get the Excel information from the user’s clipboard. You will need to use a different command to get the information depending on the user’s browser. In this example, I code specifically for Internet Explorer, but this is just since I am giving an example. In a real-world application you would code for all of the major browsers. (more…)

  • Correcting: SELECT failed because the following SET options have incorrect settings: ‘ARITHABORT’

    This error showed up on a stored procedure that I was trying to execute from an ASP.NET Web page. The strange part was that I could execute the stored procedure directly from SSMS without any problems.

    The procedure was very simple in its design, but the database I was working in was new to me and I had very limited access. The procedure was set up to receive an XML parameter and then to do a bulk insert into a table from the XML. (more…)