如何使用asp.net c＃从数据库中检索图像＃ [英] how to retrive image form the database using asp.net c #

问题描述

亲爱的

我想从sql数据库中检索图像，在sql数据库中，图像数据类型是图像，我想在图像控件中检索。 plz帮我解决

dear
I want to retrieve a image form the sql data base and in the sql database the image data type is image and i want to retrieve in the image control. plz help me out

推荐答案

try
{
    SqlCommand cmdSelect=new SqlCommand("select Picture" +
          " from tblImgData where ID=@ID",this.sqlConnection1);
    cmdSelect.Parameters.Add("@ID",SqlDbType.Int,4);
    cmdSelect.Parameters["@ID"].Value=this.editID.Text;

    this.sqlConnection1.Open();
    byte[] barrImg=(byte[])cmdSelect.ExecuteScalar();
    string strfn=Convert.ToString(DateTime.Now.ToFileTime());
    FileStream fs=new FileStream(strfn,
                      FileMode.CreateNew, FileAccess.Write);
    fs.Write(barrImg,0,barrImg.Length);
    fs.Flush();
    fs.Close();
    pictureBox1.Image=Image.FromFile(strfn);
}
catch(Exception ex)
{
    MessageBox.Show(ex.Message);
}
finally
{
    this.sqlConnection1.Close();
}

几个链接：

使用Microsoft .NET从SQL Server中检索和检索图像 [ ^ ] br />
使用ASP.NET中的数据库中的GridViewImages C＃ [ ^ ]

few links:
Storing and Retrieving Images from SQL Server using Microsoft .NET[^]
GridViewImages from DB in ASP.NET using C#[^]

这些链接可以帮助您

http://www.dotnetcurry.com/ShowArticle.aspx?ID=129 [ ^ ]

http://www.roseindia.net/answers/viewqa/Java-Beginners/21658-How-to- retrieve-image-from-database.html [ ^ ]

www.redmondpie.com/inserting-in-and-retrieving-image-from-sql-server-database-using-c/ [ ^ ]

May these links help you
http://www.dotnetcurry.com/ShowArticle.aspx?ID=129[^]
http://www.roseindia.net/answers/viewqa/Java-Beginners/21658-How-to-retrieve-image-from-database.html[^]
www.redmondpie.com/inserting-in-and-retrieving-image-from-sql-server-database-using-c/[^]

在这个例子中，我从数据库中提取了二进制代码。





SqlCommand命令=新的SqlCommand（从表中选择图像，连接）;



byte [] objByte =（（byte []）命令。 ExecuteScalar（））;



Syst em.IO.MemoryStream objStream = new System.IO.MemoryStream（objByte）;



Picture.Image = Image.FromFile（objStream）;

In this example i have fetched the binary code from the database.


SqlCommand command = new SqlCommand("Select Image From Table",Connection);

byte[] objByte = ((byte[])command.ExecuteScalar());

System.IO.MemoryStream objStream =new System.IO.MemoryStream(objByte);

Picture.Image=Image.FromFile(objStream);

这篇关于如何使用asp.net c＃从数据库中检索图像＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！