Author: learn asp.net | Posted on: 10/20/2010 8:23:41 AM | Views : 324

Hi,
I have a asp.net application in which i am downloading Excel files that are saved as BLOB in SQL database. These files use their file name in the Workbook_Open method to fill in some cells in the sheet to create templates. I am able to download file with the correct file name if i click 'Save' in the file download dialog and then open the file. This create one extra step for the user....
Is there any way by which i can click 'Open' button in the file download dialog and it gives the correct filename to the downloaded file instead of the name of the .aspx page that i am using in downloading?
Thanks in advance for all the help.
Here is my code
If myReader.Read Then Dim fileName As String Dim buffer() As Byte = Nothing Response.ClearContent() Response.ClearHeaders() fileName = "Test Data-&quo ...

Go to the complete details ...