Update existing blob data

[sam25]

Hi,
How do i update my existing blob data in my database...

For e.g my table has following column :-
varchar classname, int idnum, image data.

i have my new blob in my Byte[] newdata;

how do i update.

update mytable set classname = 'newclass', data = ???( newdata)
where idnum = searchnum.

Thanks,
Sam

[M Owen]

Use a recordset.

[sam25]

Can you please explain it in detail??? I mean how to use recorset here??