Best way to get data out of SQL Server

P

paul reed

Hello,

I have a VB.NET app that uses SQL Server. The front-end is an ASP.NET app
that runs at an ISP. I would like to let my client pull up an ASPX page,
request some pre-canned query where they perhaps supply a transaction date
range for my job table, and then I want to run that query against SQL
Server. All of this stuff I can do with no problem...but the result of the
query isn't to be displayed on a web page. I would like to have it saved on
the requesters machine in a format that excel can utilize.

Ideally after the query runs I would like it to prompt the user with a file
dialog that asks them what filename would they like to save it to.

What is the best approach to take on this? Does the data have to be
formatted a particular way, comma delimited, xml?

Thanks...Paul
 
T

Tom Ogilvy

Excel 2002 and later can read xml. I don't believe earlier versions can.

Comma delimited (CSV) should be readable by excel and would be the easiest.
 
W

Wei-Dong Xu [MSFT]

Hi paul,

Very good question!

Based on my experience on this issue, I'd suggest you can check this KB
article from Microsoft.com which will help you a lot on this issue. Please
go to:
317719 HOW TO: Export Data in a DataGrid on an ASP . NET WebForm to
Microsoft
http://support.microsoft.com/?id=317719

In addition, Microsoft Office 2000 supports HTML/XML as a native file
format which means that Excel 2000 supports XML.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Top