Writing XML from Dataset to Response Object as Binary File

[Hanover]

I have looked fot his solution, but Im not sure what to search for.

I have an asp.net based report. I need the user to be able to download
an XML file of the results so they can use the data in Excel, etc.

I do NOT want to write the file to the server first. I just want to be
able to write the contents of the Dataset into a binary file and send
it back out to the user as a download, but all in memory.

Can you give me a boost in the right direction or an article that
demonstrates this?

Dan

[Martin Honnen]

Hanover wrote:

I have an asp.net based report. I need the user to be able to download
an XML file of the results so they can use the data in Excel, etc.

I do NOT want to write the file to the server first. I just want to be
able to write the contents of the Dataset into a binary file and send
it back out to the user as a download, but all in memory.

XML is text and not binary so I am not sure why you ask about XML but
then say you want to write the dataset into a binary file.
If you have an instance of System.Data.DateSet then it has a WriteXml
method with various overloads, one takes a Stream instance so in ASP.NET
you should just be able to do e.g.
dataSetInstance.WriteXml(Page.Response.OutputStrea m)

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Charles.Deisler]

There is a really nice way to dump data out as xls stream found here..

http://www.experts-exchange.com/Prog..._21055376.html

[Hanover]

Thanks! I actually found a way to dump it directly into an Excel
File...our execs like that much better. :)