Using Ionic.Zip - Download Code from GridView in ASP.NET using c#

We bind a PDF in a GridView and then write download code using the Ionic.Zip library.

Initial Chamber

Step 1

Open your Visual Studio 2010 and create an Empty Website, provide a suitable name (gridview_demo).

Step 2

In Solution Explorer you get your empty website, then add a web form and a SQL Server database as in the following.

For Web Form:

gridview_demo (your empty website) then right-click then select Add New Item -> Web Form. Name it gridview_demo.aspx.

For SQL Server Database

gridview_demo (your empty website) then right-click then select Add New Item -> SQL Server Database. (Add a database inside the App_Data_folder).

DATABASE CHAMBER

Step 3

In Server Explorer, click on your database (Database.mdf) then select Tables -> Add New Table. Make the table like this.

Table tbl_data (Don't Forget to make ID as IS Identity -- True)

table design

Design Chamber

Step 4

Now open your gridview_demo.aspx file, where we create our design so that our application works.

Gridview_demo.aspx.cs:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{
font-size: medium;
text-decoration: underline;
color: #FF6600;
}
.style2
{
color: #FF6600;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<table style="width:100%;">
<tr>
<td class="style1">
<strong>Download Task in Gridview in asp.net</strong></td>
<td class="style2">
</td>
<td class="style2">
</td>
</tr>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" onrowcommand="GridView1_RowCommand" BackColor="White"
BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3"
GridLines="Vertical">
<AlternatingRowStyle BackColor="#DCDCDC" />
<Columns>
<asp:TemplateField HeaderText="Book No.">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("id") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Download">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="lnkbtn" runat="server" CommandName="Download" Text='<%#Bind("book")%>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#0000A9" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#000065" />
</asp:GridView>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
</table>
<br />
<br />
<br />
<br />
<br />
</div>
</form>
</body>
</html>

Your design will look like this:

design

Code Chamber

Step 5

Open your gridview_demo.aspx.cs and write some code so that our application works.

Gridview_demo.aspx.cs:

First you need to download the Ionic.Zip.dll file from the codeplex, but here in my source you will get your DLL file and in my account also there is this file you can download it from there too. Then add the namespaces as in the following image.

The following is the code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using Ionic.Zip;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
refreshdata();
}
}
public void refreshdata()
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand("select * from tbl_data",con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
GridView1.DataSource=dt;
GridView1.DataBind();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName=="Download")
{
using( ZipFile zpf = new ZipFile())
{
LinkButton lnk = (e.CommandSource) as LinkButton;
string fileName1 = lnk.Text;
string fileName = e.CommandSource.ToString();
string filePath = Server.MapPath("~/Files/" + fileName1);
zpf.AddFile(filePath, "Files");
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=DownloadedFile.zip");
Response.ContentType = "application/zip";
zpf.Save(Response.OutputStream);
Response.End();
}
}
}
}

Output Chamber

Output

I hope you like this. Have a good day. Thank you for reading.

23 Comments

Join the conversation! Your thoughts help the community grow.

Arul R11y ago
Good one !!!
Chervine Bhiwoo11y ago
Good work
- Nilesh Jadav11y ago
  Thank you sir :)
Vinodh Narayanan11y ago
good one
- Nilesh Jadav11y ago
  Thanks sir
Rahul Prajapat11y ago
Good article sir
- Nilesh Jadav11y ago
  Thank you sir
Rajeesh Menoth11y ago
Good One Nilesh Jadav
- Nilesh Jadav11y ago
  Thank you sir
Upendra Pratap Shahi11y ago
good one Nilesh Jadav Sir
- Nilesh Jadav11y ago
  Thank you sir :)
Rakesh11y ago
Good work
- Nilesh Jadav11y ago
  Thank you sir
Manas Mohapatra11y ago
Nice one..
- Nilesh Jadav11y ago
  Thank you sir
Sibeesh Venu11y ago
Nice Share!.
- Nilesh Jadav11y ago
  Thank you sir
Debasis Saha11y ago
Good One..
- Nilesh Jadav11y ago
  Thank you sir
Gopi Chand11y ago
Good work
- Nilesh Jadav11y ago
  Thank you sir
Neeraj Kumar11y ago
Nice Article
- Nilesh Jadav11y ago
  Thank you sir