retriving image from database to picturebox using c# .help me

Question

0.00/5 (No votes)

See more:

SQL

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

Posted 16-Oct-12 18:57pm

ravuravu

Add a Solution

Comments

Divya RS 17-Oct-12 1:11am

You do google this , there lot of info for this in google

3 solutions

Solution 2

C#

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

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;
}

Posted 16-Oct-12 20:03pm

ravuravu

Comments

zhale 28-Jan-13 4:08am

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

philiplobo · Accepted Answer · 2012-10-16T20:15:00

Solution 3

VB

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>

Posted 16-Oct-12 20:15pm

philiplobo

Comments

philiplobo 17-Oct-12 2:16am

this code is smaller compared to yours and easy to understand... please try using this okhey !!!! :P :D

ravuravu 17-Oct-12 2:20am

okhey but how can i retrive the image

ravuravu 17-Oct-12 2:20am

pls help me in this

philiplobo 17-Oct-12 2:25am

the first solution has d code for retriving the image from the database if u use my code to store image in database....!!!!! :P :D

ravuravu 17-Oct-12 2:29am

k,i will try to use ur code,i have any doubt then i ask u

ravuravu 17-Oct-12 2:30am

if i use the solution3 how it store to database

philiplobo 17-Oct-12 2:36am

arre dude you using insert command na to inside d insert command while passing values place a prameter and den luk into solution 3 u'll understand

ravuravu 17-Oct-12 2:35am

dear sir show the entire coding to save and retrive image in database in ur method

philiplobo 17-Oct-12 2:55am

ummmm i cannot giv u d entire code right now coz i ve d code written in vb to convert it to c# it would take time and i'm busy at work right now ...!!!!

ravuravu 17-Oct-12 3:32am

k sir i try my level best

philiplobo 17-Oct-12 3:38am

excuse me , i'm jst a student wat u calling me sir ??? :O

ravuravu 20-Oct-12 5:53am

k sorry

philiplobo · Accepted Answer · 2012-10-16T19:30:00

Solution 1

C#

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 !!!!!

Posted 16-Oct-12 19:30pm

philiplobo

Comments

ravuravu 17-Oct-12 1:37am

the image is stored in database as system.byte[]

philiplobo 17-Oct-12 1:41am

ya so it has binary data written in tables cells where the image is stored right...??? this code will work fine for that ...!!!!

ravuravu 17-Oct-12 1:44am

image is stored in tbEmployee table in the field name as Photo

ravuravu 17-Oct-12 1:45am

data type is varchar

philiplobo 17-Oct-12 1:49am

can u copy paste what data is stored in Photo col ...???

ravuravu 17-Oct-12 1:55am

empid name designation phone address photo salary place
121 raveesh accountan 9448374372 hgsdfuytdfiugh System.Byte[] 8000 tirur
2123 hari salesman 9878768576 kjhdefgsjdvbksd System.Byte[] 9000 kasargod

philiplobo 17-Oct-12 1:58am

hehe dude dats not a image . w8 fst show me ur code to store d image to database i'll tell u wats wrong !!!!

ravuravu 17-Oct-12 1:57am

i saved a picture in my sql database 2005

philiplobo 17-Oct-12 2:01am

u show me d code to add the image to your database ...!!!! den only i can understand how to retreive it from d database !!!!

ravuravu 17-Oct-12 2:03am

hey pls check my code

ravuravu 17-Oct-12 2:08am

hey i send the code in solution 2 u pls check it

ravuravu 17-Oct-12 2:09am

you can see the code in solution 2 u pls check it

philiplobo 17-Oct-12 2:17am

ya i chkd it its very confusing u please look into solution 3 ... try dat code its very easy !!!!