I've created an ASP.NET C# form that displays a record from a SQL database on the web. I can get everything to load fine except for a file stored in an "image" (datatype) field.
What I want is the page to display either a picture or a link or something that the user can click to download the file.
I can't seem to figure out is:
1. what type of object to put in the form (text link, image, etc.) to allow for a downloadable file.
2. how to assign the file contained in the image column to some sort of variable. For the other columns in the sql table I'm using:
Variable.Text = (string)dtrLinkField["SQLFIELD"];
but this doesn't work for the file stored in the sql image column.
3. How to assign the variable (in 2 above) to the form object (in 1 above) so that the user clicks (or Right-clicks/save target as) and can download the file.
Any help is greatly appreciated,