Clasic ASP download file from SQL

The reason why this doesn't appear to work is because it is basically not possible. This isn't supported for security reasons. The potential exploit that enabling this scenario would open is known as a Drive-by Download whereby a malicious webmaster could send a whole load of malware to the client in addition to the requested file. The workaround is to compress the files into one archive file, and download that instead.

There are quite a few examples that show how to do this using a variety of third party zip libraries. That's mainly because there was nothing specifically designed for this in the. NET framework until some new stuff was introduced in System. Compression in. NET 4. The simple examples that follow illustrates the use of the ZipFile.

In both cases, the user is presented with a list of checkboxes representing a selection of files to choose from. What is this Controller? Why should you care to have Controllers in your code? I may say that it is a significant part of the MVC concept, but these words mean nothing.

Where are you going to store the code for this logic? As an ASP developer you would probably create a set of pages to pull and display some data from the database, and a couple of pages to receive Forms with user input to update the database back. It is OK when the system is not too large.

It is OK when the User interacts with the system in a simple way. You will have to create some sort of "Architecture" in your code to do not get totally lost in the code when the system is finished.

When I say "Architecture" I mean some repetitive patterns of the code to handle the similar situations. Anyways the system will be a mess of HTML, SQL, code to access the database, handle user input, and display data at the end of development.

What happened if it is times bigger? A remedy for the problem is the code encapsulation with the repetitive standard structures of the code and the special agreement regarding the naming of the components. So there is a place for a special component - a Controller , which interacts with the user and contains a sort of the business logic:. Controller is a class. It holds all the aspects of user interaction mostly regarding ONE type of business entity.

There should be a number of controllers in the Application. Controller should not have a user interface code or HTML markup. It is a good practice to avoid the SQL in the controller too. Controller should handle user input, query and update the object model and prepare the data to be displayed. Controller handles the user input , do the things and controls what is going to be displayed but not how.

Controller should have methods that compose the logic of Controller. Like this:. There is no standard Router for ASP. It will be a default. The URLs we are going to employ will be similar to:. But the second one is more flexible and can be used to route the HTTP request based on the controller name. The Action is selected using the same technique. So the Controller is instantiated and one of it's Actions is called. Next, Action executes the business logic.

There may be a business logic of any kind in the controller. You may query or update the database, send e-mails, process files or user input, or even launch a rocket to Mars.

At the end of Action, if you want to display soemthing besides the static content of View you need to initialize the variable Model and include the View as the last line of the Action.

The List action prepares the list of Users and assign this list to the variable Model. Variable Model is used in the View.. Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. User posted Hi, i am trying to upload a file to SQL database and later trying to retrieve it. Please help me code to upload file to SQL database.

Thursday, August 7, AM. User posted Are you sure the retrieve page does not contain any other stuff in it? Also it's better to use Generic Handler. Friday, August 8, AM. ContentLength, but still it doesnt work. User posted For some. User posted I am having the same issues. I saved one version on my hard disk, took a copy of that version and saved it into the DB; comparing them in two Byte Arrays Now, the next step is how to get rid of that extra byte. In my case, I'm saving a document in a varbinary max column.

BTW, this works fine for any other file format except docx maybe xlsx; haven't tried. Tuesday, August 26, PM. User posted Okay, I'm back. So this is what I did to shave off the extra byte Dim b aNote.

Document i Next i Response. Write b, 0, b. Length Now I know this is not the way to do it, but when my document opens up with no problems. User posted My apologies. User posted I was having this same issue, then deleted everything from the.

Now it works just fine. Monday, September 8, PM. User posted I am having the exact same issue with. When I try to open the stoed file directly, I get the Excel error which prompts me to repair the file. Has anyone figured out a better way of fixing this other than manually playing around with the file bytes? Sunday, September 14, AM. User posted Please Add following things.. Wednesday, October 22, AM. User posted We were having the same problem. We found we had two issues in our application: 1.

When the attachment is stored in the database, we also store a mime type so we can reopen it properly. Our database column was set to 50 characters, so the end was getting trimmed off. It just so happens that it was getting trimmed in a place that made it look like it was still a valid mime type.

Apparently this worked with old document types, but not the new Office Thursday, November 6, PM. ToString and here the ashx: Imports System. Web Imports System. Services Imports System. ConnectionStrings "wpsConnectionString". ProcessRequest If context. Monday, February 16, PM. User posted This worked for me: Response. Length - 1 Basically I just trimmed 1 byte off the end.

For some reason, the image object in the database is 1 byte longer.