SQLserver C#将图片以二进制方式存储到数据库，再从数据库读出图片

一 存储到数据库

1、建立数据表UserPhoto

 userID为varchar(50)    设置为标识列unique不能重复   alter table UserPhoto add  unique(UserID)

 photo为image

2、写一个类，主要有三个方法

（1）连接数据库的类ConnectionOpen()

（2）判断图片类型转换byte[]数组ImageToBytes(Image image)

（3）操作数据库将转换的二进制写进数据库

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace importImage
{
    class Class1
    {
 
        private SqlConnection ConnectionOpen()
        {
            string connectionString = "Server = 192.168.31.214; Database =Attendance; User ID = sa ; Password = dengrui2018;";
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            return conn;
        }
 
        public static byte[] ImageToBytes(Image image)
        {
            if (image == null)
            {
                return null;
            }
            ImageFormat format = image.RawFormat;
            using (MemoryStream ms = new MemoryStream())
            {
                if (format.Equals(ImageFormat.Jpeg))
                {
                    image.Save(ms, ImageFormat.Jpeg);
                }
                else if (format.Equals(ImageFormat.Png))
                {
                    image.Save(ms, ImageFormat.Png);
                }
                else if (format.Equals(ImageFormat.Bmp))
                {
                    image.Save(ms, ImageFormat.Bmp);
                }
                else if (format.Equals(ImageFormat.Gif))
                {
                    image.Save(ms, ImageFormat.Gif);
                }
                else if (format.Equals(ImageFormat.Icon))
                {
                    image.Save(ms, ImageFormat.Icon);
                }
                byte[] buffer = new byte[ms.Length];
                //Image.Save()会改变MemoryStream的Position，需要重新Seek到Begin
                ms.Seek(0, SeekOrigin.Begin);
                ms.Read(buffer, 0, buffer.Length);
                return buffer;
            }
        }
        public bool InsertPerImage(string rowAutoID, Image perImage)
        {
            SqlConnection conn = ConnectionOpen();
 
            int i = 0;
            if (perImage == null)
            {
                SqlCommand com = new SqlCommand("insert into UserPhoto(UserID) values('100020')", conn);
                com.Parameters.Add("UserID", SqlDbType.VarChar);//数据库里userID是varchar，这里转换为varchar
                com.Parameters["UserID"].Value = rowAutoID;
                i = com.ExecuteNonQuery();
            }
            else
            {
                SqlCommand com = new SqlCommand("insert into UserPhoto(UserID,photo) values(@UserID,@photo)", conn);
                com.Parameters.Add("UserID", SqlDbType.VarChar);
                com.Parameters["UserID"].Value = rowAutoID;
 
                com.Parameters.Add("photo", SqlDbType.Image);
                com.Parameters["photo"].Value = ImageToBytes(perImage);//调用方法将图片转换为二进制
                i = com.ExecuteNonQuery();//返回受影响的函数
            }
            if (i > 0)
            {
                conn.Close();
                return true;
            }
            else
            {
                conn.Close();
                return false;
            }
        }
    }
}

3、调用方法

private void button5_Click(object sender, EventArgs e)
        {
            Class1 c1 = new Class1();
            string id = "10002";
             //调用方法  传递两个参数  编号，图片的路径
            bool aa = c1.InsertPerImage(id, Image.FromFile(@"E:\ssdVS\项目\importImage\importImage\image\bananer.jpg"));
            MessageBox.Show(aa.ToString());   //如果返回为true 则添加成功
        }

二 从数据库获取二进制转换为图片

有空完善.....