Programmatically Move Varbinary Data From One Table To Another

Hey all,

Another varbinary question.

I am trying to move an image stored in a table varbinary(max) directly from one table to another programmatically.

The rest of the data is just nvarchar(50) so I just use a T-SQL select statement in the code behind and feed all of the date into an SqlDataReader, I do this becuse there is some user interaction when the data is moved, so there may be some new values updated when transfering from one table to another, so once the old and possibly new data is stored in seperate variables then I use a T-SQL insert statement to move all of the data into the other table.

Problem is I am not really sure how to handle the image data(varbinary(max)) to just do a straight up transfer from the one table to another. I get conversion errors when trying to handle the data as a string which makes sense.

Not sure what to put for code examples since I really am stumped with this, but here is what is not working.

Dim imageX As String

SqlDataReader Code - imageX = reader("imageData")

Insert code - myCommand.Parameters.AddWithValue("@imageData", imageX)

Thanks in advance,