显示从数据库到图片框的图像 [英] Display image from database to picturebox

问题描述

我制作了一个qr代码扫描程序，当它成功检测到qr时，它会将qrcode显示到txtDecode.text（文本框）中，然后它将显示数据库中的数据。我希望在检测到qr时包含我的图像



我尝试过：



sqlCon.Open（）;



String sqlSelectQuery =SELECT * FROM SMStocksTb WHERE SmStockCode =+ int.Parse（txtDecode.Text）;

SqlCommand cmd = new SqlCommand（sqlSelectQuery，sqlCon）;

SqlDataReader dr = cmd.ExecuteReader（）;

if（dr.Read（ ））

{

lblID.Text =（dr [SmStockId]。ToString（））;

lblCode.Text =（dr [SmStockCode]。ToString（））;

lblName.Text =（dr [SmStockName]。ToString（））;

lblQty.Text =（dr [SmStockQty]。ToString（））;

lblSize.Text =（dr [SmStockSize]。ToString（））;

lblLength.Text =（dr [SmStockLength]。ToString（））;



}

sqlCon.Close（） ;

I made a qr code scanner and when it successfully detects the qr it will show the qrcode into the txtDecode.text(textbox) then it'll show the data from the database. I want my image to be included when the qr is detected

What I have tried:

sqlCon.Open();

String sqlSelectQuery = "SELECT * FROM SMStocksTb WHERE SmStockCode = " + int.Parse(txtDecode.Text);
SqlCommand cmd = new SqlCommand(sqlSelectQuery, sqlCon);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
lblID.Text = (dr["SmStockId"].ToString());
lblCode.Text = (dr["SmStockCode"].ToString());
lblName.Text = (dr["SmStockName"].ToString());
lblQty.Text = (dr["SmStockQty"].ToString());
lblSize.Text = (dr["SmStockSize"].ToString());
lblLength.Text = (dr["SmStockLength"].ToString());

}
sqlCon.Close();

推荐答案

试试这个（用实际的列名替换 SmImageColumnName ）...

Try this (where you replace SmImageColumnName with the actual column name)...

byte[] imageBytes = dr["SmImageColumnName"] as byte[];

if (imageBytes != null)
{
  using(var stream = new MemoryStream(imageBytes))
    pictureBox.Image = Image.FromStream(stream);
}

这篇关于显示从数据库到图片框的图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！