SQL Sever 2005 Image saving and retrieving

• Cube-364925

  SSC Rookie

  Points: 41

  More actions

  September 6, 2006 at 10:12 pm

  #172355

  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.Image;

  tempImg.Save(memBuffer, System.Drawing.Imaging.

  ImageFormat.Bmp);

  bfrBuffer =

  new byte[memBuffer.Length];

  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 to assign bfrBuffer in the stored procedure parameter, I think here is the problem.

  for retriving: 

  Image tempImg;

  memBuffer.Write(bytEmployee, 0, bytEmployee.Length);

  tempImg =

  Image.FromStream(memBuffer);

  picPhotograph.Image = tempImg;

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

  Can anybody help me.

  Regards,

  Nelson.

• September 11, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Ward Pond

  SSC Eights!

  Points: 999

  More actions

  September 11, 2006 at 10:20 am

  #659700

  Hi Nelson..

  What datatype is expected by the stored procedure?

  The error message suggests that the stored procedure is coded with an nvarchar parameter.  Changing it to varbinary(max) should resolve this issue.

  Hope this helps..

  ---

  Take care..

  - Ward Pond
  blogs.technet.com/wardpond