SQL UPDATE record with Image field

[Tinius]

I am trying to update a field of type IMAGE.
I am able to do this by deleting the record and then INSERTing a new record
as shown below in the commented section.

But I really want to do this with an UPDATE command as shown below in the
un-commented code. I assume this is possible.

The image is passed as a byte array called 'content'. I then want to update
the column STREAM with the new 'CONTENT'.

I don't know the correct SQL syntax for this UPDATE command.
protected static void StoreImage(byte[] content, int iID)
{
OleDbConnection con = ConnectionOledb ;
con.Open();
try
{
// update record with image
OleDbCommand update = new OleDbCommand("U PDATE Images SET [Stream] = " +
content + " WHERE ID = " + iID, con);
update.ExecuteN onQuery();

//Long winded way. Delete whole record, then replace
// OleDbCommand delete = new OleDbCommand("D ELETE * FROM Images WHERE ID "
+ iID, con);
// delete.ExecuteN onQuery();
//
// OleDbCommand insert = new OleDbCommand("I NSERT into Images ([stream],
ID) values (@image, @ID)", con);
// OleDbParameter imageParameter = insert.Paramete rs.Add("@image" ,
OleDbType.Binar y);
// imageParameter. Value = content;
// imageParameter. Size = content.Length;
// OleDbParameter IDParam = insert.Paramete rs.Add("@ID", OleDbType.Integ er);
// IDParam.Value = iID;
// insert.ExecuteN onQuery();
}
finally
{
con.Close();
}
}
--
Tinius

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You should be using parameters for the update, in the same way you are
doing it for the insert

OleDbCommand update = new OleDbCommand("U PDATE Images SET [Stream] = @image
WHERE ID = " + iID, con);

OleDbParameter imageParameter = insert.Paramete rs.Add("@image" ,
OleDbType.Binar y);
imageParameter. Value = content;
imageParameter. Size = content.Length;

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Tinius" <Ti****@discuss ions.microsoft. com> wrote in message
news:9F******** *************** ***********@mic rosoft.com...

I am trying to update a field of type IMAGE.
I am able to do this by deleting the record and then INSERTing a new
record
as shown below in the commented section.

But I really want to do this with an UPDATE command as shown below in the
un-commented code. I assume this is possible.

The image is passed as a byte array called 'content'. I then want to
update
the column STREAM with the new 'CONTENT'.

I don't know the correct SQL syntax for this UPDATE command.
protected static void StoreImage(byte[] content, int iID)
{
OleDbConnection con = ConnectionOledb ;
con.Open();
try
{
// update record with image
OleDbCommand update = new OleDbCommand("U PDATE Images SET [Stream] = " +
content + " WHERE ID = " + iID, con);
update.ExecuteN onQuery();

//Long winded way. Delete whole record, then replace
// OleDbCommand delete = new OleDbCommand("D ELETE * FROM Images WHERE ID "
+ iID, con);
// delete.ExecuteN onQuery();
//
// OleDbCommand insert = new OleDbCommand("I NSERT into Images ([stream],
ID) values (@image, @ID)", con);
// OleDbParameter imageParameter = insert.Paramete rs.Add("@image" ,
OleDbType.Binar y);
// imageParameter. Value = content;
// imageParameter. Size = content.Length;
// OleDbParameter IDParam = insert.Paramete rs.Add("@ID",
OleDbType.Integ er);
// IDParam.Value = iID;
// insert.ExecuteN onQuery();
}
finally
{
con.Close();
}
}
--
Tinius

[Tinius]

Hi Ignacio

Perfect

Thanks

Tinius

"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,

You should be using parameters for the update, in the same way you are
doing it for the insert

OleDbCommand update = new OleDbCommand("U PDATE Images SET [Stream] = @image
WHERE ID = " + iID, con);

OleDbParameter imageParameter = insert.Paramete rs.Add("@image" ,
OleDbType.Binar y);
imageParameter. Value = content;
imageParameter. Size = content.Length;

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation