Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / February 2008

Tip: Looking for answers? Try searching our database.

Open Word Document from SQL Server and Save back again

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jude_44 - 20 Feb 2008 11:26 GMT
Hi there

I currently have a site that stores versions of Word and Excel docs in SQL
Server. User can Download the file, edit it and then Upload it again, where
it is stored in SQL Server DB as a new Version.

Following complaints from users, we need to look into options to allow users
to open the word doc from SQL, and then when Save is clicked it would save
the updated document from memory back to SQL Server.

Is there any way to accomplish this (Essentially along the lines of
Sharepoint's functionality) in ASP.NET, assuming users could be using almost
any version of Word?

Any advice or ideas would be greatly appreciated!!

Thanks
Dave
John Timney (MVP) - 20 Feb 2008 13:43 GMT
Why can't you just install WSS

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

> Hi there
>
[quoted text clipped - 17 lines]
> Thanks
> Dave
Mark Rae [MVP] - 20 Feb 2008 13:50 GMT
> Is there any way to accomplish this (Essentially along the lines of
> Sharepoint's functionality) in ASP.NET, assuming users could be using
> almost
> any version of Word?

Why don't you just use SharePoint - this is one of the requirements for
which it was specifically designed...

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

Jude_44 - 20 Feb 2008 14:30 GMT
Yep, I had considered that; essentially it seems like a large amount of work.
Also, security is maintained based on specific workflow conditions, roles
and many other limitations all handled within my existing ASP.NET application
etc, and I have an existing checkin/checkout structure in place as well as
specific behind-the-scenes functionality tied to checkins/checkouts and
actual Sending of any document. To shift it all over to Sharepoint would be a
large amount of work, and would make it far more complex to handle and give a
larger attack surface for the app.
Very specific rights would be applixcable to each version of each document,
and to try and implement this in Sharepoint with all the above seems like a
large task.
If Sharepoint is the only means of accomplishing this, then so-be-it, I can
keep in mind for later versions of the application, but theres not enough
time to attempt that for our current release schedule. I was hoping there was
some means of simply getting the in-memory binary of the doc at save-time and
saving it back to SQL directly, in the same way as I do it at the moment at
document generation time on the server.

Thanks for your suggestion; if anyone else has any other ideas to add, I am
again happy to hear :)

Thanks
Dave

> > Is there any way to accomplish this (Essentially along the lines of
> > Sharepoint's functionality) in ASP.NET, assuming users could be using
[quoted text clipped - 3 lines]
> Why don't you just use SharePoint - this is one of the requirements for
> which it was specifically designed...
Mark Rae [MVP] - 20 Feb 2008 14:48 GMT
>> > Is there any way to accomplish this (Essentially along the lines of
>> > Sharepoint's functionality) in ASP.NET, assuming users could be using
[quoted text clipped - 13 lines]
> at
> document generation time on the server.

I wouldn't say that Sharepoint would be the only way of achieving what you
want but, from my experience with it, I'd say that it would be much less
work than trying to roll your own...

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

bruce barker - 20 Feb 2008 17:09 GMT
word uses webdav to talk to sharepoint. this is an open standard and you can
can write a webdav frontend to your sqlserver. sourceforge has a starter kit.

-- bruce (sqlwork.com)

> Hi there
>
[quoted text clipped - 14 lines]
> Thanks
> Dave
siccolo - 20 Feb 2008 17:44 GMT
> Hi there
>
[quoted text clipped - 14 lines]
> Thanks
> Dave

well, you can use OLE Automation in SQL Server ( look under
sp_OACreate and others in Books Online).
see my articles http://www.siccolo.com/Articles/SQLScripts/how-to-create-sql-to-convert-Excel_to
_table.html

and http://www.siccolo.com/articles/codeproject/Print_From_Stored_Procedure/how-to-p
rint-from-sql-stored_procedure.html


HTH
Mark Rae [MVP] - 20 Feb 2008 19:14 GMT
> Well, you can use OLE Automation in SQL Server

How would that help in ASP.NET...?

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

siccolo - 22 Feb 2008 00:54 GMT
> > Well, you can use OLE Automation in SQL Server
>
[quoted text clipped - 3 lines]
> Mark Rae
> ASP.NET MVPhttp://www.markrae.net

hmmm... the original title is "Open Word Document from SQL Server and
Save back again Options "...that's why I suggested SQL Server OLE
automation...sorry if I mislead author...

... more at http://www.siccolo.com/articles.asp ...

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.