Re: Storing/Retrieving Files In Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Mar 8, 9:20 am, Alexey Smirnov <alexey.smir...@xxxxxxxxx> wrote:
On Mar 8, 5:31 am, Cindy <cindyc...@xxxxxxxxxxx> wrote:





Hi.  I'm using SQL Server 2005.  I'd like to know if anyone has any
reference on how to allow users to upload a file **onto a database**.
In other words, a user can have several related files belonging to
him.  Also, I would need a syntax that allowed me to retrieve those
files.

I'm sure this is possible.  Aside from that information, can anyone
suggest whether this is the proper method?  I know I can simply store
the paths, but starting to juggle various directories is not really my
cup of tea; if there is only one directory to store all the files,
some of them might have the same name, thus creating a conflict.  That
is something I do not need to worry about if everything is stored in a
table image field.

In any case, thank you in advance for your help.

Cindy

http://www.google.com/search?hl=en&q=asp.net+upload+file+into+database- Hide quoted text -

- Show quoted text -

Priviet Alexey --

I am capable of searching Google; however, there are a couple of
questions you left unanswered. Namely, is this the proper way of
going about these things? Will the database bloat if there is too
much information in it? Any considerations or suggestions would be
helpful.

Thanks.

Cindy
.



Relevant Pages

  • Re: Storing/Retrieving Files In Database
    ... a user can have several related files belonging to ... I would need a syntax that allowed me to retrieve those ... if there is only one directory to store all the files, ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Makieng my variable Global
    ... You can use the application session state for variables you want available ... To retrieve a value from application state: ... Session is the same syntax, ... Always remember that you can store different types in state, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Newbie help
    ... think I can probably get what I need using SQL Server (the ... > To efficiently store and retrieve data for your needs, ... You only store changed values (as ...
    (microsoft.public.sqlserver.programming)
  • Re: DOCX FILE CORRUPTED WHEN RETRIEVED FROM SQL2005
    ... I am facing the same problem and would appreciate your reply on the same as it has become a show stopper for me now. ... My Code is given below to retrieve the docx content from SQL 2005 whose data type is image. ... Here is the code where i insert the file into database. ... when I store these files to the server, using the code below and similar ...
    (microsoft.public.office.developer.vba)
  • Re: Simulink store/retrieve values during simulation
    ... Is there really no way that you can store and retrieve data values during a simulink simulation like you can do with a written loop in an standard m-file? ... or in the signal processing blockset look at the buffer or delay line blocks. ...
    (comp.soft-sys.matlab)