把文件写到数据库

        /// <summary>
        ///
        /// </summary>
        /// <param name="fileName"></param>
        /// <returns></returns>
        public byte[] GetBytes(string fileName)
        {
            FileInfo fi = new FileInfo(fileName);
            FileStream fs = fi.OpenRead();
            byte[] bytes = new byte[fs.Length];
            fs.Read(bytes, 0, Convert.ToInt32(fs.Length));
            fs.Close();
            fs.Dispose();
            return bytes;
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="bytes"></param>
        public void CreateNewFile(byte[] bytes)
        {
            FileStream fileStream = new FileStream(@"D:\tes.pdf", System.IO.FileMode.CreateNew);
            fileStream.Write(bytes, 0, bytes.Length);
            fileStream.Close();
        }

 

 

             string connstring = "server=.;database=Test123;uid=;pwd=;";
            string sqltxt = "insert into testpdf([fileName],[fileContentImage],[fileContentbyte]) values(@fileName,@fileContentImage,@fileContentbyte)";

            SqlParameter[] parms = new[]{
                 new SqlParameter("@fileName", SqlDbType.VarChar){Value="123"},
            new SqlParameter("@fileContentbyte", SqlDbType.VarBinary){Value=bytes},
            new SqlParameter("@fileContentImage", SqlDbType.Image){Value=bytes},
            };
            SqlHelper.ExecuteNonQuery(connstring, CommandType.Text, sqltxt, parms);

            //4.从数据库里读取生成文件（.pdf)

            object obj = SqlHelper.ExecuteScalar(connstring, CommandType.Text, "select top 1 fileContentbyte from Testpdf order by addTime desc ");
            byte[] tempBytes = (byte[])obj;
            FileStream fileStream = new FileStream(@"D:\testByte.pdf", System.IO.FileMode.Create);

            fileStream.Write(tempBytes, 0, tempBytes.Length);
            fileStream.Close();

            System.Threading.Thread.Sleep(500);

            object obj1 = SqlHelper.ExecuteScalar(connstring, CommandType.Text, "select top 1 fileContentImage from Testpdf order by addTime desc ");
            byte[] tempBytes1 = (byte[])obj1;
            FileStream fileStream2 = new FileStream(@"D:\testImage.pdf", System.IO.FileMode.Create);

            fileStream2.Write(tempBytes1, 0, tempBytes1.Length);
            fileStream2.Close();