How do I download pdf file from SQL server and add all these files to zip folder in ASP.NET C#

Question

0.00/5 (No votes)

See more:

Hello,

I am doing web application .Here I want to download bulk of files which are stored in sql server in var-binary format and archive all in zip folder.I already create zip folder from Directory storage as follows...

What I have tried:

<pre> string path = Server.MapPath("~/Samples/");
            string[] filenames = Directory.GetFiles(path);          
            using (ZipFile zip = new ZipFile())
            {
                //Byte [] filename1=
                zip.AddFiles(list, "files");
                zip.Save(Server.MapPath("~/samplefiles1.zip"));
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Message", "alert('Zip File Created')", true);
            }

but now i want get pdf files from sql server and add to zip folder..I googled a lot but i can't .
Please help me..
thanks
Sujata

Posted 1-Feb-17 20:11pm

SujataJK

Updated 1-Feb-17 21:19pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2017-02-01T21:19:00

Solution 1

refer this article to save all the pdfs to the disc and then zip the files based on the ZipFile api
Save PDF File in SQL Server Database using C#[^]

similar question database to store for PDF,doc,pdf, and Images[^]

Posted 1-Feb-17 21:19pm

Karthik_Mahalingam

Comments

SujataJK 2-Feb-17 3:38am

thanks,Karthik sir.
As per understanding above link save individual pdf to the disc.but i want simultaneously download or create zip folder of all pdf stoared in database

Karthik_Mahalingam 2-Feb-17 3:49am

First save all the files to the disc
zip all the saved files
download the zip file using respose.write with zip content type

SujataJK 2-Feb-17 4:02am

ok..
but how can do that? as per ur above link..
string sPathToSaveFileTo = @"C:\SelectedFile.pdf";
// on this path i will create selected PDF File Data open pdf for checking

this only for selected file but i want to perform download action on btnDownloadAll_Click().i.e.Download all file in single select query.

Karthik_Mahalingam 2-Feb-17 4:29am

you should save the files in a folder inside your project directory.

SujataJK 2-Feb-17 4:05am

Following code i used for download PDF when download linkButton of gridview click.
i.e by passing particular id

protected void lnkDownload_Click(object sender, EventArgs e)
{
LinkButton lnkbtn = sender as LinkButton;
GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
int fileid = Convert.ToInt32(gvDetails.DataKeys[gvrow.RowIndex].Value.ToString());

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select Name, ContentType, Data from ImageTable where id=@Id";
cmd.Parameters.AddWithValue("@Id", fileid);
cmd.Connection = con;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.ContentType = dr["ContentType"].ToString();
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + dr["Name"] + "\"");
Response.BinaryWrite((byte[])dr["Data"]);
Response.End();
byteArray = (byte[])dr["Data"];
string result = System.Text.Encoding.UTF8.GetString(byteArray);
list.Add(result);

}
}
}

Karthik_Mahalingam 2-Feb-17 4:30am

first save all the files and then you try to zip and download..
dont do all at once, the thread will break.

SujataJK 2-Feb-17 4:43am

Ok..
i will try

SujataJK 2-Feb-17 7:47am

Thanks Karthik sir,
I got solution .
Follwoing code downloads multiple files from database and save on disc.It works perfectly in my case.

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{

// DialogResult result = this.folderBrowserDialog1.ShowDialog();
con.Open();
using (SqlCommand cmd = new SqlCommand("select Name, ContentType, Data from ImageTable"))
{
cmd.Connection = con;
DataTable objTable = new DataTable();
SqlDataAdapter objAdapter = new SqlDataAdapter(cmd);
// objAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(objAdapter);
objAdapter.Fill(objTable);
foreach (DataRow objRow in objTable.Rows)
{
byte[] objData = (byte[])objRow["Data"];
var firstNBytes = objData.Take(4);
Byte[] threeBytes = new Byte[] { objData[0], objData[1], objData[2], objData[3] };
var bytesToCompare = Encoding.Unicode.GetBytes("0x25");
bool equal = firstNBytes.SequenceEqual(bytesToCompare);
string hex = BitConverter.ToString(threeBytes);
hex.Replace("-", "");

string strFileToSave = "D:\\PDFFiles\\" + Guid.NewGuid();
if (hex == "25-50-44-46")
{
strFileToSave += ".pdf";
}
else
{
strFileToSave += ".jpg";
}

FileStream objFileStream = new FileStream(strFileToSave, FileMode.Create, FileAccess.Write);
objFileStream.Write(objData, 0, objData.Length);
objFileStream.Close();
}

}
}

Karthik_Mahalingam 2-Feb-17 8:35am

good, if it works, please close the post.