Connecting Tech Pros Worldwide Forums | Help | Site Map

Save Files from my desktop to SQL Server

JPS
Guest
 
Posts: n/a
#1: Jul 19 '08
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



Cor Ligthert[MVP]
Guest
 
Posts: n/a
#2: Jul 20 '08

re: Save Files from my desktop to SQL Server


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


"JPS" <aomw@hotmail.comschreef in bericht
news:%23a5j2Oc6IHA.4652@TK2MSFTNGP05.phx.gbl...
Quote:
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
>
>
=?Utf-8?B?U3VydHVyWg==?=
Guest
 
Posts: n/a
#3: Jul 22 '08

re: Save Files from my desktop to SQL Server


(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


"Cor Ligthert[MVP]" wrote:
Quote:
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
>
>
"JPS" <aomw@hotmail.comschreef in bericht
news:%23a5j2Oc6IHA.4652@TK2MSFTNGP05.phx.gbl...
Quote:
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
>
Closed Thread