使用C#将图像从数据库检索到图片框.帮助我 [英] retriving image from database to picturebox using c# .help me

问题描述

 i want to retrieve image from sql database to picture box using c# coding,
one thing image is saved in database as varchar form.

推荐答案

MemoryStream ms1 = New MemoryStream;
 ms1.Write(im.Item(0), 0, im.Item(0).Length);
 PictureBox1.Image = Image.FromStream(ms1);

前提是图像以二进制格式存储在数据库中！！！！！！！！！

provided the image is stored in binary format in the database !!!!!

byte[] big;
private System.Windows.Forms.OpenFileDialog OpenFD;

私有void btnBrowse_Click(对象发送者，EventArgs e)
{
//this.openFileDialog1 =新的System.Windows.Forms.OpenFileDialog();
//openFileDialog1.ShowDialog();
//txtPhoto.Text = openFileDialog1.FileName;
//picImage.Image =〜/Images" + openFileDialog1.FileName;


this.OpenFD =新的System.Windows.Forms.OpenFileDialog();
OpenFD.Title =选择文件";
OpenFD.Filter ="Jpg | * .jpg | Jpge | * .jpge | Gif | * .gif";
OpenFD.FileName = null;
字符串fileName;
如果(OpenFD.ShowDialog()！= DialogResult.Cancel)
{
//querybuilder qu =新的querybuilder();
fileName = OpenFD.FileName;
对象拒绝= System.Reflection.Missing.Value;
试试
{
//将其显示到图片框
picImage.Load(fileName);
//这里的get_image是一个函数，Big是byte []类型
大= get_image(fileName);
}
catch(ex ex例外)
{
MessageBox.Show("Error" + ex.Message.ToString());
}
}

/* OpenFileDialog fileOpen =新的OpenFileDialog();
fileOpen.Title =打开图像文件";
fileOpen.Filter ="JPG文件(* .jpg)| * .jpg";

如果(fileOpen.ShowDialog()== DialogResult.OK)
{
picImage.Image = Image.FromFile(fileOpen.FileName);
}
fileOpen.Dispose(); */
}

专用字节[] get_image(string filePath)
{
FileStream流=新的FileStream(filePath，FileMode.Open，FileAccess.Read);
BinaryReader reader =新的BinaryReader(stream);
byte []照片= reader.ReadBytes((int)stream.Length);
reader.Close();
stream.Close();

返回照片；
}

private void btnBrowse_Click(object sender, EventArgs e)
{
//this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog();
//openFileDialog1.ShowDialog();
//txtPhoto.Text = openFileDialog1.FileName;
//picImage.Image = "~/Images"+openFileDialog1.FileName;


this.OpenFD = new System.Windows.Forms.OpenFileDialog();
OpenFD.Title = "Select Files";
OpenFD.Filter = "Jpg|*.jpg|Jpge|*.jpge|Gif|*.gif";
OpenFD.FileName = null;
string fileName;
if (OpenFD.ShowDialog() != DialogResult.Cancel)
{
//querybuilder qu = new querybuilder();
fileName = OpenFD.FileName;
Object refmissing = System.Reflection.Missing.Value;
try
{
// show it to picturebox
picImage.Load(fileName);
// Here get_image is a function and Big is the byte[] type
big = get_image(fileName);
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message.ToString());
}
}

/* OpenFileDialog fileOpen = new OpenFileDialog();
fileOpen.Title = "Open Image file";
fileOpen.Filter = "JPG Files (*.jpg)| *.jpg";

if (fileOpen.ShowDialog() == DialogResult.OK)
{
picImage.Image = Image.FromFile(fileOpen.FileName);
}
fileOpen.Dispose();*/
}

private byte[] get_image(string filePath)
{
FileStream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read);
BinaryReader reader = new BinaryReader(stream);
byte[] photo = reader.ReadBytes((int)stream.Length);
reader.Close();
stream.Close();

return photo;
}

MemoryStream ms1 = New MemoryStream();
picturebox1.Image.Save(ms1, System.Drawing.Imaging.ImageFormat.Png)

'and when u insert data into the table
'place a parameter in the command 
'insert into table values(@a)
'assign the parameter value
cmd1.Parameters.AddWithValue("@a", ms1.ToArray);
'done ur image is saved to the database

</pre>

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