.Net, ASP.NET, DataTable, Excel, Excel 2003, Excel 2007, Excel 2010, MS Office, Programming, Software, VB.NET, Web Development, WebForms

Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly

I’ve been playing around with the ClosedXML.Excel library for creating or reading MS Excel documents in your ASP.NET code. Bottom line is that this tool is going to save you a lot of time:
  1. In simplifying your task of putting the Workbook and Worksheets together
  2. and I can’t stress enough how much time this will save you from trying to re-jig your Web server to serve Excel documents using the Microsoft.Office.Interop.Excel library.

Continue reading “Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly”

Advertisements
.Net, ADO.NET, ASP.NET, C#, Database, DB Connection Example, Example Connection, Programming, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, Web Development, WebForms

Basic Example of using the ASP.NET FileUpload to Save into a Database

Here is a super-simple bare-bones example of an ASP.NET Web form page in C# that uses the .NET FileUpload component to allow a user to upload a file into a SQL Server database table. I’ve put this together as a template to show just how easy it is to do and how few lines of actual code the process actually requires. Surprisingly the examples I found online and at the Microsoft support site were incomplete or had errors, so this is my attempt at making things clear. Continue reading “Basic Example of using the ASP.NET FileUpload to Save into a Database”