How to open a word document saved in sql server in asp.net

[jefftim]

Hi All

I've saved a word document in sql server database.I'm able to retrieve
it from the database and open it in a word application.
My problem is as i have to use this in an intranet application, the
word is not opening in a client machine but it is opening on the
machine the application has been hosted.

I'm extracting the word file from database and storing it on the hard
disk and in the next instance passing the file location to the shell
command and opening it.

please try to solve my problem asap.

Jeff

 

[Brendan Green]

One (of many) solutions:
when the document is retrieved from the database, save it to a temporary
file on the webserver. Then have the webpage redirect to the file. This
will cause the Word document to be opened in the web browser.

 

[jefftim]

Thank u Brendan for the suggestion. I've already tried this one. Its
working on the server but not on the client. If you have any other
solution try to post it.
I've used response.binarywrite also.

Jeff

 

[Danny]

You may try this:

byte[] btYourDoc;
btYourDoc = GetYourDocDataFromSqlServer();
Response.ContentType = "application/ms-word";
Response.AddHeader("Content-Disposition",
"attachment;filename=yourfilename.doc");
Response.BinaryWrite(btYourDoc);
Response.End();

 

[jefftim]

Hi Danny

Thanx for the code.its working

You may try this:

byte[] btYourDoc;
btYourDoc = GetYourDocDataFromSqlServer();
Response.ContentType = "application/ms-word";
Response.AddHeader("Content-Disposition",
"attachment;filename=yourfilename.doc");
Response.BinaryWrite(btYourDoc);
Response.End();

Hi All

I've saved a word document in sql server database.I'm able to retrieve
it from the database and open it in a word application.
My problem is as i have to use this in an intranet application, the
word is not opening in a client machine but it is opening on the
machine the application has been hosted.

I'm extracting the word file from database and storing it on the hard
disk and in the next instance passing the file location to the shell
command and opening it.

please try to solve my problem asap.

Jeff