Justin Cooney

Web Development Tips and Examples

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.

Month: October 2013

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

2013-10-30

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…
Correcting: SELECT failed because the following SET options have incorrect settings: ‘ARITHABORT’

2013-10-29

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…

recent posts

about

Month: October 2013

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

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