将图像从 WPF 控件保存到 SQL Server DB

Saving the Image from WPF control to SQL Server DB(将图像从 WPF 控件保存到 SQL Server DB)
本文介绍了将图像从 WPF 控件保存到 SQL Server DB的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个用 WPF 3.5 编写的应用程序,它在某些时候将数据保存在 SQL Server 中包含图像中,这是保存数据的代码的一部分(注意 this.pictureImage 是一个 WPF Image 控件):-

I have an application written in WPF 3.5 which at some point it saves the data in including an image in SQL Server, this is part of the code in saving the data (note this.pictureImage is a WPF Image control):-

using (SqlCommand command = myConnection.CreateCommand())
{
    String sqlInsertCommand = "INSERT INTO Info_Id (idNumber, FirstName, Nationality, Image) VALUES (@idNumber, @firstName, @nationality, @image)";

    command.CommandText = sqlInsertCommand;
    command.CommandType = System.Data.CommandType.Text;

    command.Parameters.AddWithValue("@idNumber", this.cardIdTextBlock.Text);
    command.Parameters.AddWithValue("@firstName", this.fullNameTextBlock.Text);
    command.Parameters.AddWithValue("@nationality", this.nationaltyTextBlock.Text);
    command.Parameters.AddWithValue("@image", this.pictureImage);

    command.ExecuteNonQuery();
}

运行此程序并单击保存到数据库按钮后,出现以下错误.

After I run this and click on the saving to DB button I got the following error.

不存在从对象类型 System.Windows.Controls.Image 到已知托管提供程序的映射

No mapping exists from object type System.Windows.Controls.Image to a known managed provider

在 SQL Server 数据库中,我有一行 (Picture (Image, null)).

In the SQL Server database I have a row with (Picture (Image, null)).

请多多指教.谢谢.

推荐答案

您无法在数据库中保存 Image 控件.相反,您应该通过适当的位图编码器在 Image 控件的 Source 属性中对图像进行编码,并将编码的缓冲区存储为字节数组.

You can't save an Image control in your database. Instead you should encode the image in the Image control's Source property by an appropriate bitmap encoder and store the encoded buffer as byte array.

byte[] buffer;
var bitmap = pictureImage.Source as BitmapSource;
var encoder = new PngBitmapEncoder(); // or one of the other encoders
encoder.Frames.Add(BitmapFrame.Create(bitmap));

using (var stream = new MemoryStream())
{
    encoder.Save(stream);
    buffer = stream.ToArray();
}

// now store buffer in your DB

这篇关于将图像从 WPF 控件保存到 SQL Server DB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Execute complex raw SQL query in EF6(在EF6中执行复杂的原始SQL查询)
SSIS: Model design issue causing duplications - can two fact tables be connected?(SSIS:模型设计问题导致重复-两个事实表可以连接吗?)
SQL Server Graph Database - shortest path using multiple edge types(SQL Server图形数据库-使用多种边类型的最短路径)
Invalid column name when using EF Core filtered includes(使用EF核心过滤包括时无效的列名)
How should make faster SQL Server filtering procedure with many parameters(如何让多参数的SQL Server过滤程序更快)
How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?(如何使用Microsoft SQL Server Management Studio生成数据库的实体关系(ER)图?)
8