Comments by aaaaaaaaaaa222 (Top 11 by date)

I am now able to do inset but cant load the image back. what do you think I should do? thanks

private void buttonsave_Click(object sender, EventArgs e)
{
Image myImage = pictureBox1.Image;
byte[] data;
using (MemoryStream ms = new MemoryStream())
{
myImage.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
data = ms.ToArray();
}

con.Open();
cmd = new SqlCommand("INSERT INTO table1(id,picture) VALUES (@id,@image)", con);
{
cmd.Parameters.AddWithValue("@image", data);
cmd.Parameters.AddWithValue("@id", textBox1.Text);
cmd.ExecuteNonQuery();
}
con.Close();
}

private void buttonbrowseimage_Click(object sender, EventArgs e)
{
// open file dialog
OpenFileDialog open = new OpenFileDialog();
// image filters
open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
if (open.ShowDialog() == DialogResult.OK)
{
// display image in picture box
pictureBox1.Image = new Bitmap(open.FileName);
}
}

private void buttonloadview_Click(object sender, EventArgs e)
{
cmd = new SqlCommand("SELECT picture FROM table1 WHERE id=@ID", con);
con.Open();
cmd.Parameters.AddWithValue("@ID", textBox1.Text);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
byte[] data = (byte[])reader["Picture"];
using (MemoryStream stream = new MemoryStream(data))
{
Image myImage = pictureBox1.Image;
myImage = new Bitmap(stream);
}
}
con.Close();
}