how to retrive image from ms access database using C#

please solve my problem

my code below

 

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.IO;

using System.Drawing.Imaging;

using System.Data.OleDb;

using Microsoft.VisualBasic;

namespace proposed_embed_system

{

public partial class Form4 : Form

{

public Form4()

{

InitializeComponent();

}

private string sql;

private OleDbDataReader reader;

OleDbConnection con;

OleDbCommand cmd;

OleDbDataAdapter adapter;

DataSet ds;

int rno = 0;

MemoryStream ms;

byte[] photo_aray;

private void Form4_Load(object sender, EventArgs e)

{

con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Embed system\\ATM.mdb");

loaddata();

showdata();

}

void loaddata()

{

adapter = new OleDbDataAdapter("select * from atm", con);

ds = new DataSet();

adapter.Fill(ds, "atm");

ds.Tables[0].Constraints.Add("pk_Account_No", ds.Tables[0].Columns[0], true);//creating primary key for Tables[0] in dataset

}

void showdata()

{

accountBox.Text = ds.Tables[0].Rows[rno][0].ToString();

textBox1.Text = ds.Tables[0].Rows[rno][1].ToString();

pictureBox3.Image = null;

if (ds.Tables[0].Rows[rno][4] != System.DBNull.Value)

{

photo_aray = (byte[])ds.Tables[0].Rows[rno][4];

MemoryStream ms = new MemoryStream();

pictureBox3.Image.Save(ms, ImageFormat.Jpeg);

byte[] PhotoByte = ms.ToArray();

}

}

public Image byteArrayToImage(byte[] byteArrayIn)

{

System.Drawing.ImageConverter converter = new System.Drawing.ImageConverter();

Image img = (Image)converter.ConvertFrom(byteArrayIn);

return img;

}

void conv_photo()

{

//converting photo to binary data

if (pictureBox3.Image != null)

{

//using MemoryStream:

ms = new MemoryStream();

pictureBox3.Image.Save(ms, ImageFormat.Jpeg);

byte[] photo_aray = new byte[ms.Length];

ms.Position = 0;

ms.Read(photo_aray, 0, photo_aray.Length);

cmd.Parameters.AddWithValue("@Fingerprint", photo_aray);

}

}

private void enterbtn_Click(object sender, EventArgs e)

{

try

{

int n = Convert.ToInt32(Interaction.InputBox("Enter Account No:", "Search", "20", 100, 100));

DataRow drow;

showdata();

drow = ds.Tables[0].Rows.Find(n);

if (drow != null)

{

rno = ds.Tables[0].Rows.IndexOf(drow);

textBox1.Text = drow[1].ToString();

pictureBox3.Image = null;

if (drow[4] != System.DBNull.Value)

{

photo_aray = (byte[])drow[4];

System.Drawing.ImageConverter converter = new System.Drawing.ImageConverter();

pictureBox3.Image = (Image)converter.ConvertFrom(photo_aray);

}

}

else

MessageBox.Show("Record Not Found");

}

catch(Exception ex)

{

MessageBox.Show(ex.Message.ToString());

}

//con.Close();

}

private void fingerprint_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

{

openFileDialog2.Filter = "jpeg|*.jpg|bmp|*.bmp|all files|*.*";

DialogResult res = openFileDialog2.ShowDialog();

if (res == DialogResult.OK)

{

pictureBox2.Image = Image.FromFile(openFileDialog2.FileName);

}

}

private void closebtn_Click(object sender, EventArgs e)

{

this.Close();

}

}

}

Hi,

 

As I suggested, Please check this link it may help you.

 

http://www.codeproject.com/Tips/465950/Why-do-I-get-a-Parameter-is-not-valid-exception-wh 

my code problem is void show data

same error when i am using your code

Hi,

 

photo_aray = (byte[])drow[4];

MemoryStream ms = new MemoryStream(photo_aray);

pictureBox3.Image = Image.FromStream(ms);

 

photo_aray = (byte[])drow[4]; 

 

System.Drawing.ImageConverter converter = new System.Drawing.ImageConverter();

pictureBox3.Image = (Image)converter.ConvertFrom(photo_aray); 

 

 

public Image byteArrayToImage(byte[] byteArrayIn)
{

System.Drawing.ImageConverter converter = new System.Drawing.ImageConverter();
Image img = (Image)converter.ConvertFrom(byteArrayIn);

return img;
} 

 

 

pictureBox3.Image  =  byteArrayToImage(photo_aray);

 

I hope this will help you. If you still have issue please check this link :

Why do I get a "Parameter is not valid." exception when I read an image from my database? 

in void show data error

line is below

 pictureBox3.Image = Image.FromStream(ms);

error is Parameter is not valid. 

 

please help  

Hi,

 

You said you are getting output as Invalid Input.

As per your code you are getting this output because your code is throwing exception.

catch

{

MessageBox.Show("Invalid Input");

} 

Try to debug your code and tell us the excat line from which your code is throwing exception so it will be easy for us to tell you what are the possible solutions for your problem.