如何使用asp.net 3.5从datagrid保存和下载pdf文件 [英] How to save and download pdf file from datagrid using asp.net 3.5

问题描述

大家好，
我正在使用asp.net，C#.net和vs2008.

我想将pdf文件保存在sql数据库中，然后从datagridview下载pdf.

任何想法或链接请给我.

谢谢与问候
mukesh

Hi All,
I am using asp.net, C#.net and vs2008.

I want to save pdf file in sql database and download pdf from datagridview.

any idea or link plz give me.

Thanks & Regards
mukesh

推荐答案

ASP.NET不支持PDF.您可以根据需要将PDF作为blob存储在数据库中，但是存储文件路径更为有效.如果将PDF存储在文件系统中，则可以链接到它们，否则需要HTTP处理程序将它们推出.

ASP.NET has no support for PDFs. You can store a PDF in your DB as a blob if you like, but it''s more efficient to store file paths. If you store the PDFs in the file system, you can just link to them, otherwise you need a HTTP handler to push them out.

请检查以下文章.这里是将pdf，doc，xls类型的所有文件转换为二进制格式，然后再次将byte []检索到文档中.

http://www.c -sharpcorner.com/UploadFile/1a81c5/convert-file-to-byte-array-and-byte-array-to-files/ [

Check the below article. Here am converting any files of type pdf, doc, xls to binary format and again retrieving byte[] to the document.

http://www.c-sharpcorner.com/UploadFile/1a81c5/convert-file-to-byte-array-and-byte-array-to-files/[^]


also try this.
You can have column varbinary in your table and you can save your images/files there.

Please see the sample table.

create table uploadtest
(
id int primary key,
filename varchar(500),
filecontent varbinary(max)
)


I have attached a sample working solution for demo purposes in the below thread.


http://www.c-sharpcorner.com/Forums/Thread/179342/how-to-upload-and-retrieve-files-from-database.aspx[^]


For demo purposes i have set to upload and download one file only.

Also i have used Entity framework, if you are using stored procedures, create a class with the above columns as properties and set the values or directly pass the stored proc content to filename and file content

Please dont forget to mark my answer as accepted if it works.

这篇关于如何使用asp.net 3.5从datagrid保存和下载pdf文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！