Can someone please brief me on how to save 'pdf' files(there are about 15 files) into a SQL database and retrieve/open it from a datagrid?
I have about 15 pdf files on my webserver and need to save it in the SQL database, so every pdf file saved in the database will have a primary key and the file will be saved either as 'ntext' or 'binary' type...I just have this rough idea.
If someone has a ready code in VB.net then nothing better( i know thats a shortcut :) but it will help me like a tutorial. C# code will do too, I can then convert the code to Vb.net
OFF: Do you really need to save 'pdf' files into a database? Wouldn't it be better to save 'pdf' files in the filesystem and save their path in the database? I think the performance in this case would be better.
Firstly thanks a lot for the reply. actually thats what my manager wants me to do...but I agree with you about the file system and saving it's path, I am sure it will also reduce the complexity of code behind.I already have the pdf files on the web server so
probably saving the path will work well...in any case if you have a ready solution for doing this or if you can help me with how to go about it, I can handle it further on.
arty
Member
241 Points
61 Posts
How to save pdf files to SQL database?
Sep 26, 2005 06:51 AM|LINK
Hi all,
Can someone please brief me on how to save 'pdf' files(there are about 15 files) into a SQL database and retrieve/open it from a datagrid?
I have about 15 pdf files on my webserver and need to save it in the SQL database, so every pdf file saved in the database will have a primary key and the file will be saved either as 'ntext' or 'binary' type...I just have this rough idea.
If someone has a ready code in VB.net then nothing better( i know thats a shortcut :) but it will help me like a tutorial. C# code will do too, I can then convert the code to Vb.net
Thanks a ton.
...we live more than once!
drozdovsky
Member
10 Points
2 Posts
Re: How to save pdf files to SQL database?
Sep 26, 2005 03:40 PM|LINK
arty
Member
241 Points
61 Posts
Re: How to save pdf files to SQL database?
Sep 26, 2005 11:46 PM|LINK
Firstly thanks a lot for the reply. actually thats what my manager wants me to do...but I agree with you about the file system and saving it's path, I am sure it will also reduce the complexity of code behind.I already have the pdf files on the web server so probably saving the path will work well...in any case if you have a ready solution for doing this or if you can help me with how to go about it, I can handle it further on.
thankyou once again, your help is appreciated.
...we live more than once!