Word Document in Browser From SQL 2000
-
Hi, I'm hoping someone can help me with a problem - I'm a newbie, and trying to write a somewhat simple app. I've gotten Word documents uploaded to my SQL server, using the FileUpload Demo as a model. With the documents in SQL Server (image column), I need to be able to pull them out and open them, either in a browser window, or in the Word app - either one is fine. The code below shows how I'm trying it now, but it seems that since I'm writing out to the .aspx page using Response. OutputStream, the application doesn't see it as a Word document, even though I've set the ContentType properly as "application/msword". They are retrieved from the SQL server OK - my problem is opening them either in the browser (preferred) or in the Word app. On my laptop, they open as gibberish in Front Page, rather than Word. Can someone show me the error of my ways and help me fix this problem? I'd really, really appreciate it! My code to do this is as follows: private void ShowTheFile(long FileID) { // Define SQL select statement string SQL = "SELECT FileSize, FileData, ContentType, FileName FROM tUserDocuments WHERE UniqueFileID = " + FileID.ToString(); // Create Connection object SqlConnection sqlCon = new SqlConnection(RM.GetConnString()); // Create Command Object SqlCommand sqlComm = new SqlCommand(SQL, sqlCon); // Open Connection sqlCon.Open(); // Execute command and receive DataReader SqlDataReader dbRead = sqlComm.ExecuteReader(); // Read row dbRead.Read(); // Clear Response buffer Response.Clear(); string conType = RM.Clean((string)dbRead["ContentType"]); byte[] fileData = (byte[])dbRead["FileData"]; int fileSize = (int)dbRead["FileSize"]; long fileID = FileID; string fileName = RM.Clean((string)dbRead["Filename"]); // Set ContentType to the ContentType of our file Response.ContentType = conType; // Write data out of database into Output Stream Response.OutputStream.Write(fileData, 0, fileSize); // Close database connection sqlCon.Close(); // End the page Response.End(); } Thanks VERY much for any help you can give. Mike in Bangkok -- modified at 0:55 Monday 12th September, 2005
-
Hi, I'm hoping someone can help me with a problem - I'm a newbie, and trying to write a somewhat simple app. I've gotten Word documents uploaded to my SQL server, using the FileUpload Demo as a model. With the documents in SQL Server (image column), I need to be able to pull them out and open them, either in a browser window, or in the Word app - either one is fine. The code below shows how I'm trying it now, but it seems that since I'm writing out to the .aspx page using Response. OutputStream, the application doesn't see it as a Word document, even though I've set the ContentType properly as "application/msword". They are retrieved from the SQL server OK - my problem is opening them either in the browser (preferred) or in the Word app. On my laptop, they open as gibberish in Front Page, rather than Word. Can someone show me the error of my ways and help me fix this problem? I'd really, really appreciate it! My code to do this is as follows: private void ShowTheFile(long FileID) { // Define SQL select statement string SQL = "SELECT FileSize, FileData, ContentType, FileName FROM tUserDocuments WHERE UniqueFileID = " + FileID.ToString(); // Create Connection object SqlConnection sqlCon = new SqlConnection(RM.GetConnString()); // Create Command Object SqlCommand sqlComm = new SqlCommand(SQL, sqlCon); // Open Connection sqlCon.Open(); // Execute command and receive DataReader SqlDataReader dbRead = sqlComm.ExecuteReader(); // Read row dbRead.Read(); // Clear Response buffer Response.Clear(); string conType = RM.Clean((string)dbRead["ContentType"]); byte[] fileData = (byte[])dbRead["FileData"]; int fileSize = (int)dbRead["FileSize"]; long fileID = FileID; string fileName = RM.Clean((string)dbRead["Filename"]); // Set ContentType to the ContentType of our file Response.ContentType = conType; // Write data out of database into Output Stream Response.OutputStream.Write(fileData, 0, fileSize); // Close database connection sqlCon.Close(); // End the page Response.End(); } Thanks VERY much for any help you can give. Mike in Bangkok -- modified at 0:55 Monday 12th September, 2005
hi there, Maybe u r lacking of this statement: Response.AppendHeader("Content-Disposition", "attachment;filename=word.doc"); try this << >>