Access Database

Jul 28 2008 11:39 PM
Hi.. I'm working with databases, Access databases to be exact, and I have a database in which there is an OLE Object type to store pictures. I have no problem retrieving these pictures and showing them in a picturebox, and actually I have no problem saving them to the database. The problem arises when I try to RETRIEVE the pictures that I'VE saved to the database through the application I've written. If I put an image in via access, I can retrieve no problem. If I put an image in via my windows form, and later try to retrieve it and throw it back into a picture box, I get the following error:

System.ArgumentException: Parameter is not valid.
at System.Drawing.Bitmap..ctor(Stream stream)



I suppose, since the error ONLY arrives when I try to bring in one of the pictures saved through the form that it is the method in which its being saved, but I'll post the code for both saving and retrieving.

Saving:
Byte[] byPicture;
MemoryStream ms = new MemoryStream();
picPicture.Image.Save(ms, picPicture.Image.RawFormat);
byPicture = ms.ToArray();
..........
DataRow newRow = thisConnection.adoDataSet.Tables["Categories"].NewRow();
newRow["Picture"] = byPicture;



Retrieving:
Byte[] byPicture;
MemoryStream ms = new MemoryStream();
byPicture = (Byte[])thisConnection.adoDataSet.Tables["Categories"].Rows[rowPos]["Picture"];
ms.Write(byPicture, 78, byPicture.Length - 78);
try
{

     Bitmap bm = new Bitmap(ms);
     picPicture.Image = bm;
}
catch (ArgumentException ae)
{
      string message = ae.ToString();
      MessageBox.Show(message);
}


Answers (3)