Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
521 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
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!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

861 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