Best way to get data out of SQL Server

  • Thread starter Thread starter paul reed
  • Start date Start date
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
 
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.
 
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.
 
Back
Top