iam use this code for download
download is correct but after downlaod when open file type zip file or pdf see this error
..\jcoverflip-1.0.2.zip: The archive is either in unknown format or damaged
protected void LAtt_Click(object sender, EventArgs e)
{
string str = String.Empty;
Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["bakerConnectionString"].ToString());
Cmd = new SqlCommand();
Cmd.CommandText = "SELECT * FROM Tcomplaint where id_complaint=@id_complaint";
Cmd.Parameters.AddWithValue("@id_complaint", int.Parse((Request.QueryString["id"].ToString())));
Cmd.Connection = Conn;
if (Conn.State == ConnectionState.Closed)
Conn.Open();
SqlDataReader reader = Cmd.ExecuteReader();
reader.Read();
/* اگر خانه ای با رکورد مورد نظر پیدا کند*/
if (reader.HasRows)
{
if (!reader.IsDBNull(reader.GetOrdinal("FuploadFilesname")))
str = reader.GetString(reader.GetOrdinal("FuploadFilesname"));
if (!reader.IsDBNull(reader.GetOrdinal("Fupload")))
{
//LAtt.Text = "یک فایل ارسال شده";
Response.Clear();
Response.Buffer = true;
Response.ContentType = reader.GetString(reader.GetOrdinal("FContentTypeAttachFile"));
Response.AddHeader("content-disposition", "attachment;filename=" + str);
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.BinaryWrite((byte[])reader["Fupload"]);
Response.Flush();
Response.End();
}
}
Conn.Close();
Conn.Dispose();
}
