Link to home
Create AccountLog in
Avatar of bmanmike39
bmanmike39

asked on

How do i create a Excel file out of a SQL report on the fly for a web page? (asp.net C#)

We have a site where the user is able to select the type of report they need, but to make the data useful to them, we need a way for them to press a button, and an Excel file is  created (or some file that can be opened in Excel ie.. separates the data fields).  The way we will handle the file after it is created is auto generate an email with a link for download.

Thanks !
ASKER CERTIFIED SOLUTION
Avatar of Miguel Oz
Miguel Oz
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of bmanmike39
bmanmike39

ASKER

I tried this but got the following error:

"CreateCSVFile"   does not exist in the current context
Thanks, this is just what i was looking for.