► Store
private void btnupload_Click(object sender, EventArgs e)
{
try
{
openFileDialog1.ShowDialog(this);
openFileDialog1.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
byte[] image;
string strFn=openFileDialog1.FileName;
FileStream fs = new FileStream(strFn, FileMode.Open);
BinaryReader reader = new BinaryReader(fs);
image = reader.ReadBytes((int)fs.Length);
fs.Close();
OleDbConnection conn = new OleDbConnection("ConnectionString");
conn.Open();
string query = "Insert into pictures (name,images) values(@name,@images)";
OleDbCommand comm = new OleDbCommand(query, conn);
comm.Parameters.AddWithValue("name", Path.GetFileName(strFn).ToString());
comm.Parameters.AddWithValue("images", image);
comm.ExecuteNonQuery();
MessageBox.Show("Record Added");
conn.Close();
bind();
pictureBox1.Image = new Bitmap(strFn);
}
catch (Exception)
{
throw new ApplicationException("Failed loading image");
}
}
► display
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(Program.c);
OleDbDataAdapter da=new OleDbDataAdapter("Select images from pictures",conn);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Open();
//display 1st image
if (dt.Rows.Count > 0)
{
byte[] storedImage = (byte[])dt.Rows[0]["images"];
Image newImage;
MemoryStream stream = new MemoryStream(storedImage);
newImage = Image.FromStream(stream);
pictureBox1.Image = newImage;
}
}