Image from database to Windows Forms

Question

private void button2_Click(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection("Data Source=SYS12;Initial Catalog=Teju;Integrated Security=True");
    SqlCommand cmd = new SqlCommand("Select Picture from tblImgData where id= " + listBox1.SelectedValue + " ", con);
    con.Open();
    byte[] byteImg = (byte[])cmd.ExecuteScalar();
    string strfn = Convert.ToString(DateTime.Now.ToFileTime());
    FileStream fs = new FileStream(strfn, FileMode.CreateNew, FileAccess.Write);
    fs.Write(byteImg, 0, byteImg.Length-1);
    fs.Flush();
    fs.Close();
    pictureBox1.Image = Image.FromFile(strfn);
}

This code showing error as "Out of memory." What might I be doing wrong, or how can I debug and solve this? Thanks!

score 2 · Accepted Answer · answered Mar 16 '12 at 11:19

Use System.Drawing.Image Class to save file then directly assign this image to your picture box.

Check this:

private void button2_Click(object sender, EventArgs e)
{

    SqlConnection con = new SqlConnection("Data Source=SYS12;Initial Catalog=Teju;Integrated Security=True");
    SqlCommand cmd = new SqlCommand("Select Picture from tblImgData where id= " + listBox1.SelectedValue + " ", con);
    con.Open();
    byte[] byteImg = (byte[])cmd.ExecuteScalar();
    string strfn = Convert.ToString(DateTime.Now.ToFileTime());
   Stream stream = new MemoryStream(byteImg);
Image img = System.Drawing.Image.FromStream(stream);

img.Save(strfn , ImageFormat.Jpeg);
    pictureBox1.Image = img;
}

Bridge · Answer 2 · 2012-03-16T10:40:13.263

1

Not disposing of your objects won't help. Either use the try/finally blocks or a using statement to clean up after yourself.

edited Mar 16 '12 at 10:40

answered Mar 16 '12 at 10:27

Bridge

29,818
9
60
82

Image from database to Windows Forms

2 Answers2