managing documents stored in database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dariusz Tomon
    #1

    managing documents stored in database

    Hello,

    I have to design and develop web application (ASP.NET 2.0). The main point
    of it will be managing documents stored into database (SQL Server 2005).
    Advice me please how can I do it.
    What is the best field type to store documents (Word, Excel, PDF). Maybe new
    varbinary(max)? -maybe other.
    How can I perform inserting, deleting, editing etc. documents in database
    via ASP.NET 2.0 page.
    What web control should be used (maybe upload file?). And what code behind
    could be invoked to perform these tasks.

    Best Regards

    Darek T.


    Tags: None
    • dtarczynski
      #2
      Re: managing documents stored in database

      On 4 Kwi, 23:14, "Dariusz Tomon" <d.to...@mazars .plwrote:
      Hello,
      >
      I have to design and develop web application (ASP.NET 2.0). The main point
      of it will be managing documents stored into database (SQL Server 2005).
      Advice me please how can I do it.
      What is the best field type to store documents (Word, Excel, PDF). Maybe new
      varbinary(max)? -maybe other.
      How can I perform inserting, deleting, editing etc. documents in database
      via ASP.NET 2.0 page.
      What web control should be used (maybe upload file?). And what code behind
      could be invoked to perform these tasks.
      >
      Best Regards
      >
      Darek T.
      Hi
      You can use BLOB fields for storing data. But if you have to modify
      data you should get it from database to something like MemoryStream
      then change and put it to database. I thing uploading files to
      directories (and editing etc) should be simplier.

      Regards
      Dariusz Tarczynski

        Comment

        • Steve C. Orr [MCSD, MVP, CSM, ASP Insider]
          #3
          Re: managing documents stored in database

          I've detailed the answers to all your questions in this free article:
          http://SteveOrr.net/articles/EasyUploads.aspx


          --
          I hope this helps,
          Steve C. Orr,
          MCSD, MVP, CSM, ASPInsider
          http://SteveOrr.net



          "Dariusz Tomon" <d.tomon@mazars .plwrote in message
          news:emwQ$4vdHH A.4688@TK2MSFTN GP04.phx.gbl...
          Hello,
          >
          I have to design and develop web application (ASP.NET 2.0). The main point
          of it will be managing documents stored into database (SQL Server 2005).
          Advice me please how can I do it.
          What is the best field type to store documents (Word, Excel, PDF). Maybe
          new varbinary(max)? -maybe other.
          How can I perform inserting, deleting, editing etc. documents in database
          via ASP.NET 2.0 page.
          What web control should be used (maybe upload file?). And what code behind
          could be invoked to perform these tasks.
          >
          Best Regards
          >
          Darek T.
          >
          >

            Comment

            Previous template Next
            Working...