I am using VB
.net with Sql server to add images in to the table.
This is how I did it but could not work:
mycommand.commandtext = "INSERT INTO student_master" & _
" ( st_picture, st_signature)" & _
" values ( @picture1, @picture2)" & _
" where student_id = @stu_id"
mycommand.parameters.add( "@picture1", picturebox1.image)
mycommand.parameters.add( "@picture2", picturebox2.image)
mycommand.parameters.add( "@stud_id", txtstudent_id.text)
I also tried EXEC SP_tableoption student_master, 'txt In row', 'ON'
on the table and executed the above code again; but did not work
I also tried UPDATE statement instead of INSERT statement, but still can not work.
I also need some help to retrieve images from table on to the forms of Vb
Adamu sufi :)