I Have A Binary File From database. I need To download multiple file at a time
This code is help to download Single File From Database i need to download multiple file at a time
- protected void download(object sender, EventArgs e)
- {
- con.Open();
- SqlCommand cmd = new SqlCommand("select FileName, FileType, FileData from upload where Id=@id", con);
- cmd.Parameters.AddWithValue("@id",((LinkButton)sender).CommandArgument);
- SqlDataReader dr = cmd.ExecuteReader();
- if (dr.Read())
- {
- Response.AddHeader("Content-Disposition", "attachment;filename=\"" + dr["FileName"] + "\"");
- Response.BinaryWrite((byte[])dr["FileData"]);
- Response.End();
- }
- con.Close();
- }
- }
- }