How to insert an existing image into a table from another table

Question

i have a table include an image field, i need to insert that image field to another table like this :

SqlDataAdapter da = new SqlDataAdapter(select id,stdpic from student)
dt.Clear(); da.Fill(dt);
insert into team(teamid,teampic)values('"+dt.Rows[0][0].tostring()+"','"+dt.Rows[0][1].tostring()+"')

how to do it?

Answer 1

You are going to have to choose a new format, maybe a varbinary