C#

OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=mydb.mdb");
OleDbCommand cmd = new OleDbCommand(query,connection);

try {
  connection.Open();
  cmd.ExecuteNonQuery();
}
catch {
 //Whatever needs to be catched
}
finally {
  connection.Close();
}

private byte[] getImageBytes()
{
   byte[] buffer = new byte[templateStream.Length];
   
   using(FileStream templateStream = File.Open(@"C:\MyImage.gif", FileMode.Open))
   {
      templateStream.Write(buffer, 0, (int)templateStream.Length);
      templateStream.Flush();
   }
   return buffer;
}

private byte[] getImageBytes()
{
   return File.ReadAllBytes(@"c:\MyImage.gif");
}

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Bought a House!
Judah Himango

Judah Himango wrote:

templateStream.Write(buffer, 0, (int)templateStream.Length);

Judah Himango wrote:

Setting it to null is pointless; you only need to do that in Java.

<br />
private byte[] getImageBytes()<br />
{<br />
   byte[] buffer = new byte[templateStream.Length];<br />
   using(FileStream templateStream = File.Open(@"C:\MyImage.gif", FileMode.Open,FileAccess.Read)) <br />
   {<br />
      templateStream.Read(buffer, 0, (int)templateStream.Length);<br />
      templateStream.Flush();<br />
   }<br />
   return buffer;<br />
}<br />
<br />

thomasa wrote:

templateStream.Write(buffer, 0, (int)templateStream.Length);

// Open a filestream on "C:\MyImage.gif" for Read/Write.
FileStream templateStream = File.Open(@"C:\MyImage.gif", FileMode.Open);
 
// Create an array of bytes with every element initialized to 0.
buffer = new byte[templateStream.Length];
 
// WRITE the array of 0's to the file!!!  :wtf:
templateStream.Write(buffer, 0, (int)templateStream.Length);