如何用C#和SQL将数据库存储的图片加载至WinForm的PictureBox控件
WinForm 实现数据库二进制图片回显到PictureBox的方法
当前实现现状
- 已完成的逻辑:双击DataGrid控件内的行时,对应学生的文本类信息可正常显示在二级学生信息窗体中
- 现存问题:保存学生数据时,已经将PictureBox内的图片转为字节数组、以VarBinary类型存入数据库的Image字段;但加载回显时,无法将从数据库读取的二进制图片数据转换为Image对象,赋值给PictureBox实现图片同步展示
现有代码片段
窗体加载回显逻辑
public bool IsUpdate { get; set; } private void StudentForm_Load(object sender, EventArgs e) { //For Update Process if (this.IsUpdate == true) { using (SqlConnection con = new SqlConnection(AppConnection.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("usp_Student_ReloadDataForUpdate", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@StudentName", this.StudentName); if (con.State != ConnectionState.Open) con.Open(); DataTable dtStudent = new DataTable(); SqlDataReader sdr = cmd.ExecuteReader(); dtStudent.Load(sdr); DataRow row = dtStudent.Rows[0]; StudentNameTextBox.Text = row["StudentName"].ToString(); AgeTextBox.Text = row["Age"].ToString(); GenderTextBox.Text = row["Gender"].ToString(); DescriptionTextBox.Text = row["Description"].ToString(); // 待实现:IdPictureBox.Image = row["Image"].??? SaveButton.Text = "Update Student Information"; DeleteButton.Enabled = true; } } } }
回显逻辑对应的查询存储过程
CREATE PROCEDURE usp_Student_ReloadDataForUpdate ( @StudentName NVARCHAR(200) ) AS BEGIN SELECT [StudentId] ,[StudentName] ,[Age] ,[Gender] ,[Description] ,[Image] FROM [dbo].[Students] WHERE StudentName = @StudentName END
学生数据保存逻辑(含图片存库)
private void SaveButton_Click(object sender, EventArgs e) { if(IsFormValid()) { using (SqlConnection con = new SqlConnection(AppConnection.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("usp_Student_InsertNewStudent", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@StudentName", StudentNameTextBox.Text.Trim()); cmd.Parameters.AddWithValue("@Age", AgeTextBox.Text.Trim()); cmd.Parameters.AddWithValue("@Gender", GenderTextBox.Text.Trim()); cmd.Parameters.AddWithValue("@Description", DescriptionTextBox.Text.Trim()); var image = IdPictureBox.Image; using (var ms = new MemoryStream()) { image.Save(ms, image.RawFormat); cmd.Parameters.Add("@Image", SqlDbType.VarBinary).Value = ms.ToArray(); } cmd.Parameters.AddWithValue("@CreatedBy", LoggedInUser.UserName); if (con.State != ConnectionState.Open) con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Student is successfully updated in the database.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); ResetFormControl(); } } } }
实现方案
直接替换原有代码中待实现的PictureBox赋值逻辑即可,核心是把数据库取出的字节数组通过内存流转换为Image对象:
// 替换原注释行的图片回显逻辑 if (row["Image"] != DBNull.Value) { byte[] imageBytes = (byte[])row["Image"]; using (MemoryStream ms = new MemoryStream(imageBytes)) { IdPictureBox.Image = Image.FromStream(ms); } } else { // 无有效图片数据时清空控件显示 IdPictureBox.Image = null; }
实操注意事项
- 该转换逻辑与现有图片存库逻辑完全匹配:存库时通过MemoryStream把Image转成字节数组,读取时通过MemoryStream把字节数组转回Image,格式上不会出现兼容问题
- 必须对Image字段的DBNull值做判断,避免老数据没有存图片时触发类型转换报错
- 内存流必须通过using语句包裹,及时释放非托管资源,避免长期运行出现内存泄漏
- 如果读取图片时报“参数无效”错误,优先检查数据库Image字段的VarBinary长度设置是否足够:如果长度设置过小,存库时就会截断图片字节,导致读到的数据是损坏的,无法正常生成Image对象
内容的提问来源于stack exchange,提问作者minTwin
相关产品推荐
相关产品推荐

