数据库上传图片及裁剪图片

INSERT tb(photo)

    SELECT img FROM OPENROWSET(BULK 'c:\me.jpg',SINGLE_BLOB) AS T(img);

 

裁剪图片

 /// <summary>
        /// 压缩图片并居中裁剪
        /// </summary>
        /// <param name="imageSource">源图片</param>
        /// <param name="dHeight">裁剪到高度</param>
        /// <param name="dWidth">裁剪到宽度</param>
        /// <returns></returns>
        public byte[] CropPic(System.Drawing.Image imageSource, int dHeight, int dWidth)
        {
            ImageFormat tFormat = imageSource.RawFormat;
            Bitmap oB = new Bitmap(dWidth, dHeight);
            Graphics g = Graphics.FromImage(oB);
            g.Clear(Color.WhiteSmoke);
            g.CompositingQuality = CompositingQuality.HighQuality;
            g.SmoothingMode = SmoothingMode.HighQuality;
            g.InterpolationMode = InterpolationMode.HighQualityBicubic;
            g.DrawImage(imageSource, new Rectangle(0, 0, dWidth, dHeight), (imageSource.Width - dWidth * imageSource.Height / dHeight) / 2, 0, dWidth * imageSource.Height / dHeight, imageSource.Height, GraphicsUnit.Pixel);
            MemoryStream stream = new MemoryStream();
            oB.Save(stream, ImageFormat.Jpeg);
            return stream.ToArray();
        }