C#保存文件或读取数据库文件 另存为

/// <summary>
        /// 保存文件到数据库
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            string conn = @"Data Source=YANGYIBANG\SQLEXPRESS;Initial Catalog=joe;Integrated Security=True";
            SqlConnection cn = new SqlConnection(conn);
            Stream myStream = null;
            OpenFileDialog openFileDialog1 = new OpenFileDialog();

            //openFileDialog1.InitialDirectory = "c:\\";
            //openFileDialog1.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*";
            //openFileDialog1.FilterIndex = 2;
            openFileDialog1.RestoreDirectory = true;

            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    FileInfo fi = new FileInfo(openFileDialog1.FileName);
                    FileStream fs = fi.OpenRead();
                    byte[] bytes = new byte[fs.Length];
                    fs.Read(bytes, 0, Convert.ToInt32(fs.Length));
                    SqlCommand cm = new SqlCommand();
                    cm.Connection = cn;
                    cm.CommandType = CommandType.Text;
                    if (cn.State == 0) cn.Open();
                    cm.CommandText = "insert into title (titileName, files ) values('aaa',@file)";
                    SqlParameter spFile = new SqlParameter("@file", SqlDbType.Image);
                    spFile.Value = bytes;
                    cm.Parameters.Add(spFile);
                    cm.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
                }
            }

            

        }


        /// <summary>
        /// 从数据库就读取文件另存为
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {

            
            string conn = @"Data Source=YANGYIBANG\SQLEXPRESS;Initial Catalog=joe;Integrated Security=True";
            SqlConnection cn = new SqlConnection(conn);
            SqlDataReader dr = null;
            SqlCommand cm = new SqlCommand();
            cm.Connection = cn;
            cm.CommandType = CommandType.Text;
            cm.CommandText = "select  files  from title where titileId=5";
            cn.Open();
            dr = cm.ExecuteReader();
            byte[] File = null;
            if (dr.Read())
            {
                File = (byte[])dr[0];
            }

            dr.Close();
            cn.Close();
          
                /*
                 * 直接另存为文件
                 * 
                 */ 
            SaveFileDialog saveFileDialog1 = new SaveFileDialog();
            Stream myStream;

            if (saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                if ((myStream = saveFileDialog1.OpenFile()) != null)
                {
                    using (BinaryWriter bw = new BinaryWriter(myStream))
                    {
                        // Add some text to the file.
                        bw.Write(File);
                    }

                }
            }
                
           
            }
            catch (Exception ex)
            {

                MessageBox.Show("Error: Could not read file from db. Original error: " + ex.Message);
            }
        }