title: how to download multiple files from database in asp.net c#
body: <p>This is code for downloading single file. I need to download  multiple files on single click in a zip folder on local machine</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 (MySqlConnection con = new MySqlConnection(constr))
      {
          using (MySqlCommand cmd = new MySqlCommand())
          {
              cmd.CommandText = "select Name, Data, ContentType from tblFiles where Id=@Id";
              cmd.Parameters.AddWithValue("@Id", id);
              cmd.Connection = con;
              con.Open();
              using (MySqlDataReader 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>
  
  <p>thank you in advance</p>