View Single Post
 
Old 01-05-2016, 09:28 AM
PlausiblyDamp's Avatar
PlausiblyDamp PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

Is it throwing any exceptions or just not updating the database?

Without trying the code itself the bit
Code:
tblNewPics = ds.Tables("Picture_Temp")
tblNewPics = tblPicture.Clone

For i = 0 To tblPictureCount
    tblNewPics.ImportRow(tblPicture.Rows(i))
    Dim dr2 As DataRow = tblNewPics.Rows(i)
    dr2.SetAdded()
Next
looks like it might be the problem as you seem to be getting the contents of the Picture_Temp table and then discarding the results and replacing them with a copy of the Pictures table.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote