Fórum Download de um documento do BD para o computador #488618

 protected void btnUpload_Click(object sender, EventArgs e)
        {
            //Verifica se algum arquivo foi selecionado
            if (upload.HasFile)
            {
                //Instancia a conexão com banco,capturando a string de conexão no web.config
                using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
                {
                    conn.Open();
                    string comandoSQL = "insert into TB_Documento(NomeDocumento,Documento) values(@NomeDocumento,@Documento)";
                    using (SqlCommand cmd = new SqlCommand(comandoSQL, conn))
                    {
                        //Parâmetros
                        cmd.Parameters.Add("@NomeDocumento", SqlDbType.NVarChar, 100).Value = upload.FileName;
                        cmd.Parameters.Add("@Documento", SqlDbType.VarBinary).Value = upload.FileBytes;

                        //executa a inserção
                        cmd.ExecuteNonQuery();
                    }
                }
            }
        }


        protected void btnDownload_Click(object sender, EventArgs e)
        {

            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());

            conn.Open();



            SqlCommand oSqlCommand = new SqlCommand();

            oSqlCommand.Connection = conn;
            oSqlCommand.CommandText = "SELECT Documento FROM TB_Documento Where CodDocumento = 1;";
            oSqlCommand.CommandType = CommandType.Text;

            SqlDataReader oSqlDataReader = oSqlCommand.ExecuteReader();

            byte[] buffer = null;

            if (oSqlDataReader.Read())
            {
                buffer = (byte[])oSqlDataReader.GetValue(0);
            }



            conn.Close();

            StreamWriter oStreamWriter = new StreamWriter(@"C:\Users\thais.nogueira\Documents\Visual Studio 2012\Projects\Upload\Copy_file.pdf");

            oStreamWriter.BaseStream.Write(buffer, 0, buffer.Length);

            oStreamWriter.Close();
            oStreamWriter.Dispose();

        }