Put .PDF file into SQL Database

Every invoice printer from the AS/400 will create a .pdf file into a PC.
I want to put all our archive Invoices into SQL Server.
Please let me know the requirment in creating the DB.
How to load the document into the SQL Table?
How to retrieve the document from the SQL Table?
and How to re-load the document into the SQL Table?
I would like to know the different in how to handle it between a thick
client use VB.Net / C#.Net and ASP.NET.Kam
Why not just storing files on filesystem ?
http://www.aspfaq.com/show.asp?id=2149
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:F365CE62-FEE2-42BA-BFF1-95997D2C6D03@.microsoft.com...
> Every invoice printer from the AS/400 will create a .pdf file into a PC.
> I want to put all our archive Invoices into SQL Server.
> Please let me know the requirment in creating the DB.
> How to load the document into the SQL Table?
> How to retrieve the document from the SQL Table?
> and How to re-load the document into the SQL Table?
> I would like to know the different in how to handle it between a thick
> client use VB.Net / C#.Net and ASP.NET.
>|||The type of application you are describing is called a document management
system, and it is a common pattern. There are scores of examples and sample
applications on the web, so just google on "document management system and
asp.net"
http://www.asptoday.com/Content.aspx?id=2236
Binary files can be stored in a SQL Server columns of type [image].
http://msdn.microsoft.com/library/d...r />
_8orl.asp
Importing the files into SQL Server would be best handled by a DTS / SSIS
package or client side application. It sounds like perhaps this be a
background process rather than an end user managed process. However, if
uploading via the web is a requirement then:
http://msdn2.microsoft.com/en-us/library/ms227669.aspx
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:F365CE62-FEE2-42BA-BFF1-95997D2C6D03@.microsoft.com...
> Every invoice printer from the AS/400 will create a .pdf file into a PC.
> I want to put all our archive Invoices into SQL Server.
> Please let me know the requirment in creating the DB.
> How to load the document into the SQL Table?
> How to retrieve the document from the SQL Table?
> and How to re-load the document into the SQL Table?
> I would like to know the different in how to handle it between a thick
> client use VB.Net / C#.Net and ASP.NET.
>