Sql Server 2005 Image Storage and Retreival

[ProgGuru]

Hi,

I have a problem in the Image storing and retrieving at SQL Server 2005, my code is:

-----------------------------------------------------------------------------

for storing:

Image tempImg;

tempImg = (Image) picPhotograph.I mage;


tempImg.Save(me mBuffer, System.Drawing. Imaging.ImageFo rmat.Bmp);

bfrBuffer = new byte[memBuffer.Lengt h];

memBuffer.Read( bfrBuffer, 0, (int)memBuffer. Length);

----------------------------------------------------------------------------

I am sending bfrBuffer using stored procedure to SQL server 2005, by when executing for storage, getting error as "Operand type clash: image is incompatible with varchar", I am using DBtype.binary (I can't able use SqlDbtype.Image , because my framework don't support) to assign bfrBuffer in the stored procedure parameter, I think here is the problem.

----------------------------------------------------------------------------

for retriving:

Image tempImg;

memBuffer.Write (bytEmployee, 0, bytEmployee.Len gth);

tempImg = Image.FromStrea m(memBuffer);

picPhotograph.I mage = tempImg;

--------------------------------------------------------------------------

Here I am getting "parameter not valid" in the "tempImg = Image.FromStrea m(memBuffer);".

Can anybody help me.

Regards,

Nelson.