Fileupload to SQL DB and FIledownload using visual studio 2008
I am trying to creat a fileupload page in my ASP.NET web project. I need to upload files to a SQL database. The files will be larger than the 8000byte limit of the varbinary data type. I cannot use varbinary(max) my server does not have this in the web controls database setup.( What is the best way to store files of say 1 - 5mb in size ) do i need to upload files to a directory on the server and store the file information and Path in the DB. I need to creat a file download link on the datagrid that enables users to download the files off the server too . I have tried several of the tutorials on the net but to no end. Every where I read how simple this is with the new ASP.NET. I beg to differ, I have been on this for days.