Save Files from my desktop to SQL Server

  • Thread starter Thread starter JPS
  • Start date Start date
J

JPS

We have a ASP.Net/SQL Server application that is used as a document
management system. The documents are stored per project. The files are
stored on a file server but we store the file name in the database and when
displaying the files build a grid at run time to allow users to view the
files like http://servername/files/filename.doc

The problem we have currently is users have to use the web form to upload
the files to database. Most users will work in thier local pc and when done
will use the form to upload the file.

What we want them to be able to do is to Right Click on any document/file
and select "Save to Doc Manager" function. They enter the project id and the
file is then saved automatically using the same method that is used on the
web. i.e. copy the file to a specific location and add an entry to the sql
server table.

Does anyone know how this can be achieved?

Thanks
Jas
 
JPS,

I have never don this, but it should in my idea be possible.

Add a context menu to your standard windows menu and use that to start a
program using application start.

http://msdn.microsoft.com/en-us/library/aa753589.aspx

The program (a console application) does nothing more then to show a
FileOpenDialog and add the choosen file to the SQL server.

(It is in my idea not simple not possible to find the file in the running
program as that can have more than one file).

Probably you need to use SQL Server authithencation as you want to make your
live simple.

However not a job for a simple sample here.

Cor
 
(I'm making this suggestion because I hate windows shell extensions :-)

Have you considered a little windows forms application that allows the user
to drag files onto it? It could be a ClickOnce project, if you want it to be
distributed via a webpage. Some CD/DVD burning apps use this type of UI.

For usability, you might need to set the .TopMost property to TRUE, or you
could make it a systray app.

--
David Streeter
Synchrotech Software
Sydney Australia
 
Back
Top