C# byte[]如何写入数据库

1、百度图库选一张图。

3、//添加需要的usingusing System;using System.Data;using System.Drawing;using System.Windows.Forms;using System.Data.SqlClient;using System.IO;

5、写一个图片函数 //图片函数 private byte[] GetImageBytes(Image image) { Bitmap bmp = new Bitmap(image); MemoryStream mstream = new MemoryStream(); bmp.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg); mstream.Seek(0, SeekOrigin.Begin); //及时定位流的开始位置 byte[] byteData = new Byte[mstream.Length]; mstream.Position = 0; mstream.Read(byteData, 0, byteData.Length); mstream.Close(); return byteData; }

8、图片保存到数据库对应数据表事件，应根据自己的数据表字段写SQL语句//图片保存事件 private void Btn_Save_Click(object sender, EventArgs e) { byte[] imageBytes = GetImageBytes(Img_Box.Image); string SqlStr = "INSERT INTO DBImg(ID,Name,Img)VALUES(1,'测试图片',@ImgData)"; SqlCommand cmd = new SqlCommand(SqlStr, conn); SqlParameter param = new SqlParameter("ImgData", SqlDbType.VarBinary, imageBytes.Length); param.Value = imageBytes; // 如果数据库关闭，则打开数据库 if (conn.State == ConnectionState.Closed) try{conn.Open();} catch (Exception ex) {MessageBox.Show("打开数据库失败，请检查数据设置." + ex.Message, "消息提示", MessageBoxButtons.OK, MessageBoxIcon.Stop); return;} cmd.Parameters.Add(param); int i = cmd.ExecuteNonQuery(); MessageBox.Show(i + " 条图片数据保存成功"); }