Solved

Using Softartisans ExcelWriter, do you know if I can generate an Excel file from either a SQL Server 2005 table, stored procedure or query and if so how?

Posted on 2013-12-17
1
512 Views
Last Modified: 2013-12-21
I am developing my first C# ASP.NET web application using web forms and VS2010.
I plan on using SoftArtisans ExcelWriter to create Excel files from a SQL Server 2005 database.

Using Softartisans ExcelWriter, do you know if I can generate an Excel file from either a SQL Server 2005 table, stored procedure or query and if so how?
0
Comment
Question by:zimmer9
1 Comment
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39725395
... OfficeWriter samples demonstrate how to import data from a database into an Excel or Word report. All .NET samples that connect to a database use the ADO.NET System.Data.SqlClient namespace to connect to Microsoft SQL Server and the AdventureWorks 2000 sample database.
Have you looked at the OfficeWriter examples? I usually find examples useful for this type of software. See:
http://windemo.softartisans.com/OfficeWriter/3.9.2/aspnet.aspx
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question