How to retrieve image form database

Sandeep Singh

10y938LINQ

Using this below code i am able to send my images to the database thru Linq to Sql

but i am unable to retrieve the images in PictureBox

private void btnUpload_Click(object sender, EventArgs e)
{
openFileDialog1.FileName = "";
openFileDialog1.Filter ="Jpeg Images(*.jpg)|*.jpg|Bitmap Images(*.bmp)|*.bmp|All Images(*.*)|*.*";
DialogResult dr = openFileDialog1.ShowDialog();
if (dr == DialogResult.OK)
{
imgPath = openFileDialog1.FileName;
pictureBox1.ImageLocation = imgPath;
}
}

Insert into Database-->

private void btnInsert_Click(object sender, EventArgs e)
{
int? Cid = null;
if (imgPath.Trim().Length > 0)
{
byte[] data = File.ReadAllBytes(imgPath);
Binary img = new Binary(data);
dc.Customer_Insert(textBox2.Text, textBox3.Text, decimal.Parse(textBox4.Text), int.Parse(textBox5.Text),
img, ref Cid);
textBox1.Text = Cid.ToString();
}
else
{
dc.Customer_Insert(textBox2.Text, textBox3.Text, decimal.Parse(textBox4.Text), int.Parse(textBox5.Text),
null, ref Cid);
textBox1.Text = Cid.ToString();
}
}

I want to display the image along with the whole information of Customer in my Window Application

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Singh10y ago
Bikesh SrivastavaandRajeesh Menothi know how to retrieve the image using ADO.Net, I want to retrieve the image from the data base using Linq to Sql
Thanks for your reference
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Threading.Tasks;
usingSystem.Windows.Forms;
usingSystem.Data.Linq;
usingSystem.IO;
usingMicrosoft.VisualBasic;
namespaceLinqDeve
{
publicpartialclassForm1:Form
{
DeveloperDataContextdc;stringimgPath="";byte[]data=null;
intrno=0;
publicForm1()
{
InitializeComponent();
}
privatevoidbtnUpload_Click(objectsender,EventArgse)
{
openFileDialog1.FileName="";
openFileDialog1.Filter="JpegImages(*.jpg)|*.jpg|BitmapImages(*.bmp)|*.bmp|AllImages(*.*)|*.*";
DialogResultdr=openFileDialog1.ShowDialog();
if(dr==DialogResult.OK)
{
imgPath=openFileDialog1.FileName;
pictureBox1.ImageLocation=imgPath;
}
}
privatevoidbtnInsert_Click(objectsender,EventArgse)
{
int?Cid=null;
if(imgPath.Trim().Length>0)
{
byte[]data=File.ReadAllBytes(imgPath);
Binaryimg=newBinary(data);
dc.Customer_Insert(textBox2.Text,textBox3.Text,decimal.Parse(textBox4.Text),int.Parse(textBox5.Text),
img,refCid);
textBox1.Text=Cid.ToString();
}
else
{
dc.Customer_Insert(textBox2.Text,textBox3.Text,decimal.Parse(textBox4.Text),int.Parse(textBox5.Text),
null,refCid);
textBox1.Text=Cid.ToString();
}
}
privatevoidForm1_Load(objectsender,EventArgse)
{
dc=newDeveloperDataContext();
}
privatevoidbtnClear_Click(objectsender,EventArgse)
{
textBox1.Text=textBox2.Text=textBox3.Text=textBox4.Text=textBox5.Text="";
pictureBox1.ImageLocation="";
data=null;
textBox2.Focus();
}
privatevoidbtnSearch_Click(objectsender,EventArgse)
{
intCid;imgPath="";data=null;
stringvalue=Interaction.InputBox("EnterEmployeeNumber");
boolStatus=int.TryParse(value,outCid);
if(Status)
{
Customerobj=dc.Customers.SingleOrDefault(C=>C.Cid==int.Parse(value));
textBox1.Text=obj.Cid.ToString();
textBox2.Text=obj.Cname;
textBox3.Text=obj.Job;
textBox4.Text=obj.Salary.ToString();
textBox5.Text=obj.Age.ToString();
//pictureBox1.Image=??
}
}
pictureBox1.Image= ?? i am stuck up here only
Bikesh Srivastava10y ago
Hi,
you are doing good .its little bit mistake i think ,you use debug and check value from database,because we can't debug on your code.
Rajeesh Menoth10y ago
Hi,

Please check the following reference :

http://net-informations.com/csprj/dataset/cs-retrieve-image.htm

http://www.c-sharpcorner.com/UploadFile/8ea152/fetch-image-from-database-in-windows-form-application/

How to retrieve image form database

Bikesh SrivastavaandRajeesh Menothi know how to retrieve the image using ADO.Net, I want to retrieve the image from the data base using Linq to Sql