Displaying the pdf file in grid

Posted by Gokul under Regular Expressions on 12/6/2010 | Points: 10 | Views : 1905 | Status : [Member] | Replies : 2
Dear Friends
Can any one explain how to store the pdf file in DB and how to retrieve from DB and display in Grid with its name?


Regards
Gokul.N

Thanks and Regards,
GokulNath Nithy.



Responses

Posted by: Vuyiswamb on: 12/19/2010 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
I am not a fan of storing files in the Database, the main reason is that the retrieval of this files can be a performance hit, it is better to store the path of the file than the file it self. Well to store any file in the db you need to convert it to and save it and when you need to retrieve it , you need to do some casting back to the original file name and type. here are some few examples
http://chiragrdarji.wordpress.com/2007/08/31/storing-and-retrieving-docpdfxls-files-in-sql-server/
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/a91e4a05-25b2-449a-9d51-08e54fef702c/

Thank you for posting at Dotnetfunda
[Administrator]

Gokul, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 1/10/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

Check this link

http://www.beansoftware.com/ASP.NET-Tutorials/Binary-Files-To-Database.aspx

It shows on how to upload the image, same way use the pdf as well which is compatible which this code.

Thanks
Karthik
www.f5Debug.net

Gokul, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response