Hi,

I have been searching for an answer to this for a long time and still can't find one.

Is it possible to retrieve a document from a database in DotNetNuke? I have code that does this in my .Net website and it works perfectly but when I created a custom module that retrieves the documents using the same code, I get an error "The remote host closed the connection. The error code is 0x80070057." Am I wasting my time trying to do this or does anyone know if it can be done. These documents are already stored in the Client's database so I can't just store them in a repository somewhere. My client is now wondering if I've made a mistake by choosing DotNetNuke as the CMS because of the limitations. I am using DNN 6.2.2.

Here is the code to retrieve the document:

public static bool openDocument(int iDocID, int languageID)
        {
            using (var ctx = Components.Data.Model.DecisionReportModel.Instance())
            {
                var doc = from d in ctx.DocumentLanguages.Include("Document").Where(dd => dd.DocumentID == iDocID && dd.LanguageID == languageID)
                          select d;

                var document = doc.FirstOrDefault();

                HttpContext.Current.Response.Buffer = false; //I've tried true as well

                HttpContext.Current.Response.Clear();
                if (document.Document.FileSize > 0)
                {
                    string strFileName = document.Document.FileName;
                    HttpContext.Current.Response.ContentType = document.Document.ContentType;
                    HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName.ToString());
                    HttpContext.Current.Response.OutputStream.Write(document.FileContent, 0, ((int)document.Document.FileSize));

                    HttpContext.Current.Response.Flush();
                    HttpContext.Current.Response.Close();
                    HttpContext.Current.Response.End();

                    return true;
                }
                return false;
            }
        }

Hi Michael,

Does that mean that I would have to put all of my documents into this "Database" folder.

Unfortunately, that won't work for me. These documents are already in the database and another web application (not a DNN site) that I've created allows users to upload documents to this database while my DNN module in this application is supposed to read from this database and display these documents and any new document that gets uploaded. I could technically upload my 8 gb worth of documents to this folder that you suggested but I'd be duplicating these documents and this folder would not include and new documents that get uploaded from my user.

Thanks anyway,