SQL2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have developed a .NET application in ASP.NET 2.0.
The website consists of administration module (sort like CMS) where users
can update data and images that I store into an SQL DB.

One of my tables has a Column Type = Image to store the images into my DB
and I would like to have the possibility to update and insert new images into
my DB associated with the text info the user provides.

When updating or inserting new info, I receive the following error :

"Operand type clash: nvarchar is incompatible with image"

Could someone help me with this ?

Thanks,
Bart
 
1. Create a SQL Server stored procedure that accepts the image type.
2. Have the image converted to a byte array
3. Attach this byte array to the image parameter

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************
 
Back
Top