Re: Save Files from my desktop to SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

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@xxxxxxxxxxx> schreef in bericht news:%23a5j2Oc6IHA.4652@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Upload image into SQL Server database
    ... How do I build the form so that includes both an insert into an SQL Server ... "Kevin Spencer" wrote in message ... > path to the image in the database. ... >> I need them to be able to upload an image as well and to have it saved ...
    (microsoft.public.frontpage.programming)
  • Re: Mange Large file in the database
    ... With a big amount of data that is uploaded to SQL server from the Web you ... MS SQL can handle huge amount of data. ... model for your database. ... project is to upload data from clinte machine and save these data to SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error 3702: database in use and cannot be deleted
    ... in an ASP.NET database application with SQL Server 2000 users can archive records from a production database in archive ... On a web form of the server application users can view data of the archive database in a datagrid webcontrol. ... ' SQL Server connection should always be closed! ...
    (microsoft.public.sqlserver.programming)
  • Re: ASPNET hosting problem
    ... Do I have to upload the .cs files and the .resx files?Also the .sln file, ... > need to change it to point to the Sql Server accessible by your host. ... > load those too. ... > If you have to set up the database, it may be best to speak to your ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASPNET hosting problem
    ... Upload a single test.aspx page that just response.write ... >> need to change it to point to the Sql Server accessible by your host. ... >> load those too. ... >> If you have to set up the database, it may be best to speak to your ...
    (microsoft.public.dotnet.framework.aspnet)