Respected Mitchel Sellers,

I'm been working for dnn since 3 months and have been delivered to modules to internal customer of my org.

Currently i'm upgrading my helpdesk asp.net application to dnn module. I've done all the work except attachment work. Previously i was using msaccess db and storing all the attachments in db now i'm working on mssql.

I'm searching daily internet to find some tips to work with files, dnn, and mssql but could not reach any solution.

I' learnt how to put imageurl to image control if images are stored in mssql image datatype table in normal aspnet application. But most of gurus of webapps recommends to store files in filesystem instead of storing in db.

As i'm upgrading my normal asp.net app to dnn, I'm not able to load an image to image control from database nor any idea of storing fileupload postedfile to filesystem.

Please guide me how to fix these issues. The rest of work has been done. 

Also i found an error in dnn 5.2.0, I found if a file which is not allowed to unathenticated users and if linkClick.aspx?f=*** link is sent to any one via email and he clicks on the link than he is shown 404 error. I think dnn should prompt the user to login page if file is restricted for unathenticated users.

 Actually I want to use dnn filesystem (linkclick)  but URL control is not appropriate for my requirement. I want to manage files in the following herarchy

portal/myapp/files/caseid/filename.ext

I don't know how to add files and folders programmatically into dnn file system so that i can get file id and linkclick url. I want to store fileid in databse only for attachments if any posted in helpdesk.

Further more: in asp.net app, if we are trying to load image from mssql db to an image control we usually create another page ex. loadimage.aspx?id=12 and put this to image control imageurl property and image fetched from database and loaded to control dynamically. I don't know how to get the same feature in my dnn module.