how to save file from database to user's local disc using asp.net(VB)

[simonyong]

Hello, anyone
I had search for few days with how to save file when user choose a file name from listbox and i will search the file from database and user can save it into their desktop

what I had done currently is uploading a file to database but totally no idea about how to "download" from database

the following is my codes to upload file to database:

 If Not (myFile.PostedFile Is Nothing) Then
 
            OpenConn()
            Dim intFileNameLength As Integer, bytData() As Byte
            Dim objStream As System.IO.Stream
            Dim strFileNamePath As String
            Dim strFileNameOnly As String
 
            intFileNameLength = myFile.PostedFile.ContentLength
            ReDim bytData(intFileNameLength)
            objStream = myFile.PostedFile.InputStream
            objStream.Read(bytData, 0, intFileNameLength)
 
            strFileNamePath = myFile.PostedFile.FileName
            intFileNameLength = InStr(1, StrReverse(strFileNamePath), "\")
            strFileNameOnly = Mid(strFileNamePath, (Len(strFileNamePath) - intFileNameLength) + 2)
 
            Dim cmd As OracleCommand
            cmd = New OracleCommand("INSERT INTO test (filename, filesave) Values ('" + strFileNameOnly + "',:1)", myCN)
            cmd.CommandType = CommandType.Text
 
            Dim param As OracleParameter = cmd.Parameters.Add("filesave", OracleDbType.Blob) ' Bind the parameter as OracleDbType.Blob to command for inserting image
            param.Direction = ParameterDirection.Input
 
            param.Value = bytData                                                           ' Assign Byte Array to Oracle Parameter
            cmd.ExecuteNonQuery()
 
            CloseConn()
            Label1.Text = "File Upload Success."
        End If
 

Please help me/ giv me some direction to go, I hav no idea at all
Thanks in advance

[shansund]

For txt File

Step 1:

Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + "." + "txt")

fileName -> Give the File Name which you download

Step2:
Set the Content type

  Response.ContentType = "application/x-download"

Step 3:

  Response.Charset = ""
  Response.WriteFile(<here Path>)
  Response.End()
 Response.Flush()

[Frinavale]

For txt File

Step 1:

Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + "." + "txt")

fileName -> Give the File Name which you download

Step2:
Set the Content type

  Response.ContentType = "application/x-download"

Step 3:

  Response.Charset = ""
  Response.WriteFile(<here Path>)
  Response.End()
 Response.Flush()

I'm just going to explain what Shansund was getting at here.
What you need to do is create an ASPX page that will not display a web page. Instead this ASPX page will send the content of the file that you retrieve from your database to the user's.

To do this you need to add an ASPX page to your project and delete any content that is automatically generated.

Make sure you leave the <%@Page ... %> directive at the top of the page (this links to your back end server code)

From there you need to set the page's content type to the file type that you are sending to the person (so that the browser knows what to expect as content since it's not going to be a web page).

Then in your Page Load event you want to retrieve the file from the database and write it to your Response stream (this is sent to the browser) and flush this so that it is sent.

Now in your main ASPX page put a link to the one you just added...when the click the link (or button) it will load the new aspx page and the content will be downloaded.

-Frinny