一存储到数据库

1、建立数据表UserPhoto

userID为varchar(50)设置为标识列unique不能重复alter table UserPhotoadd 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 = dengrui;";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到Beginms.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，这里转换为varcharcom.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 则添加成功}