"Out of memory" error when trying to read an image from sql database?

Question

0.00/5 (No votes)

See more:

In my windows form I've made a textbox which the user uses to enter the website address and then click a button to screen scrap that website into a browser control. They can also save that screen scraped website to an sql database. Now the screen scraped page is saved to database as an image and is display in the database as binary data. I have added a picture box an text box to my windows form, which the user uses to enter in the ID number of the image in the database, then click a button, which reads the image from the database into a picture box. I have put the code in for this, but when I run the program and click the button for the reading, it comes up with an error saying "Out of memory"?

Here is my code

private void btnRead_Click(object sender, EventArgs e)
{
    // set up data connection
    SqlConnection cs = new SqlConnection("Data Source=MASTER\\MASTER;Initial Catalog=FilmDB;Integrated Security=True");
    // Set up adapter manager
    SqlDataAdapter da = new SqlDataAdapter();
    // Data set
    DataSet ds = new DataSet();
    SqlCommand com = new SqlCommand("Select WebsiteImage From Website Where WebsiteID = @ID", cs);

        com.Parameters.Add("@ID", SqlDbType.Int,1);
        com.Parameters["@ID"].Value = this.txtId.Text;

        cs.Open();
       byte[] barrImg = (byte[])com.ExecuteScalar();
      string strfn = Convert.ToString(DateTime.Now.ToFileTime());
       FileStream fs = new FileStream (strfn,  FileMode.CreateNew);
       fs.Write(barrImg,0, barrImg.Length);
       fs.Flush();
       fs.Close();
       picRead.Image = Image.FromFile(strfn);


        cs.Close();
}

Posted 19-May-11 11:12am

programmer1234

Updated 19-May-11 11:31am

v4

Add a Solution

Comments

yesotaso 19-May-11 17:25pm

Irrelevant maybe but what does com.ExecuteNonQuery(); do? Second from bottom line.

programmer1234 19-May-11 17:31pm

Whoops, dont actually need that there as it doesnt do anything.

1 solution

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)

fcronin · Answer 1 · 2011-05-19T11:30:00

Found the following block here... Retrieve Image[^]

public Stream DisplayImage(int theID)
{ 
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString());
string sql = "SELECT image FROM Table1 WHERE id = @ID";
SqlCommand cmd = new SqlCommand(sql,connection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ID", theID);
connection.Open();
object theImg = cmd.ExecuteScalar();
try
{ 
return new MemoryStream((byte[])theImg);
}
catch
{ 
return null;
}
finally
{ 
connection.Close();
}
}