title: Downloading multiple files from database using C#
body: <p>Iam working on a nomination portal. Users submit their nominations along with some attachments. Number of attachments may vary from 3 to 10 for each nomination. So for each nomination evaluators have to download 10 files each at a time, which is so hectic. So I thought of providing an option to download all attachments related to a nomination at once as a Zip file. I was able to download single file at once. Please provide me a solution to download multiple files at a time along with some sample code snippet. Following is the code I'm using for downloading a single file 
  for file downloading. I am storing file content as Binary in Database</p>
  
  <pre><code>protected void DownloadFile(object sender, EventArgs e)
  {
      int id = int.Parse((sender as LinkButton).CommandArgument);
      byte[] bytes;
      string fileName, contentType;
      string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
      using (SqlConnection con = new SqlConnection(constr))
      {
          using (SqlCommand cmd = new SqlCommand())
          {
              cmd.CommandText = "select Name, Data, ContentType from tblFiles where Id=@Id";
              cmd.Parameters.AddWithValue("@Id", id);
              cmd.Connection = con;
              con.Open();
              using (SqlDataReader sdr = cmd.ExecuteReader())
              {
                  sdr.Read();
                  bytes = (byte[])sdr["Data"];
                  contentType = sdr["ContentType"].ToString();
                  fileName = sdr["Name"].ToString();
              }
              con.Close();
          }
      }
      Response.Clear();
      Response.Buffer = true;
      Response.Charset = "";
      Response.Cache.SetCacheability(HttpCacheability.NoCache);
      Response.ContentType = contentType;
      Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName);
      Response.BinaryWrite(bytes);
      Response.Flush(); 
      Response.End();
  }
  </code></pre>