October 2013
-
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…
-
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…