protected void Page_Load(object sender, EventArgs e)
        {
            string ID = Request.QueryString["recordID"];
            //  --- получение  и сохранение PDF архивного файла-
            string connectionstring = "Data Source=i7.iocsha;User ID=пользователь;Password=пароль";
 
            using (SqlConnection sqlConnection = new SqlConnection(connectionstring))
            {
                SqlCommand sqlCommand = new SqlCommand("use home; SELECT scan FROM archiv WHERE id = " + ID, sqlConnection);
                sqlConnection.Open();
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                if (sqlDataReader.HasRows)
                {
 
                    foreach (DbDataRecord record in sqlDataReader)
                    {
                        try
                        {
                            HttpResponse response = HttpContext.Current.Response;
                            //ContentType = "image/jpeg";"application/pdf"
                            response.ContentType = "application/pdf";
                            response.ClearContent();
                            response.OutputStream.Write((byte[])record["scan"], 0, ((byte[])record["scan"]).Length);
                            response.End();
                            response.Flush();
                        }
                        catch
                        {
 
                        }
                        finally
                        {
 
                        }
                    }
 
                }
                sqlConnection.Close();
 
            }
 
        }