Issue with opening a file that I am downloading.

[mike55]

Hi all

 

I am downloading a .csv file will some data in it. The code that I am using is as follows:

 Private Sub DownloadFile(ByVal filePath As String, ByVal fileName As String)
       Dim fs As FileStream


       ' Open the file.
       fs = File.Open(filePath, FileMode.OpenOrCreate)
       Dim byBytes(Convert.ToInt32(fs.Length)) As Byte
       fs.Read(byBytes, 0, Convert.ToInt32(fs.Length))
       fs.Close()

       ' Delete the file from the system.
       If Not fileName = "SampleCSV.csv" Then
           File.Delete(filePath)
       End If
       Response.AddHeader("Content-disposition", "attachment; fileName=" + fileName)
       Response.ContentType = "application/octet-stream"
       Response.BinaryWrite(byBytes)
       Response.End()

 

The issue that I am experiencing is that when the user clicks the "Open" button, I get the following error message:

'C:\Documents and Settings\user\Local settings\Temporary Internet Files\Content.IE5\0t6lg1s3\SampleCSV[1].csv' Could not be found. Check the spelling of the file name, and verify that the location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.

 

Any suggestions? Should I be employing a different means of downloading the file?

 

Mike55.

[mike55]

Problem solved. Here is what I used:

FileStream liveStream = new FileStream(localfilename, FileMode.Open,
                                      FileAccess.Read);

byte[] buffer = new byte[(int)liveStream.Length];
liveStream.Read(buffer, 0, (int)liveStream.Length);
liveStream.Close();

Response.Clear();
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Length", buffer.Length.ToString());
Response.AddHeader("Content-Disposition", "attachment; filename=" +
                  originalFilename);
Response.BinaryWrite(buffer);
Response.End();

 

Mike55.

[mike55]

Ok, I am after deploying my code from the test server to the real server. On the test server, all of the above worked correctly. When I click the download button, I get the Open Save dialog box. However, when I click on the open option, my file is opened in the existing web page.

 

Any suggestions why this is occuring?

 

Mike55.

[mike55]

I am still having the problem with the file being opened on a web browser window. I am also have the problem in that if I try to save my file I get an error message telling me that the file cannot be found. Now I have found the following code, and I have tested it on the real web server, as opposed to the test web server. The file in question opens and can be saved correctly. The issue that I am experiencing is that there is code information regarding the web page also included in the file (See attachment).

 

Dim root As String = "C:\Suretxtlog\Templates\"

       Dim filePath As String = "C:\Suretxtlog\Templates\SampleCSV.csv"

       If Not filePath Is Nothing Then
           If System.IO.File.Exists(filePath) And filePath.StartsWith(root) Then
               Dim filename As String = System.IO.Path.GetFileName(filePath)
               Response.Clear()
               Response.ContentType = "Application/x-msexcel"
               Response.AddHeader("Content-Disposition", "attachment; filename=" & filename & ".csv")
               Response.Flush()
               Response.WriteFile(filePath)
           End If
       End If

Any suggestions on how I can prevent this additional information being included in the file.

 

Mike55.

Edited November 10, 2006 by mike55