How to Export sql data to text file in web page

[Guest]

Hi.

have someone can give me some idea how to start.
the thing i want do is using web page export the sql data to text file then
let user download.
eg. the webpage has one button. when user click that button.
the webpage will go to database generate data and then export to text file.
and user will download that text file.

Thank You

 

[Morten Wennevik [C# MVP]]

Hi.

have someone can give me some idea how to start.
the thing i want do is using web page export the sql data to text file then
let user download.
eg. the webpage has one button. when user click that button.
the webpage will go to database generate data and then export to text file.
and user will download that text file.

Thank You

You can use Using an SqlDataAdapter to read the sql data to a DataSet, you can then use DataSet.WriteXml to produce a text file of the data.

 

[Guest]

HI.
Thank you.
i go check that 2 function first