Hi All,
I have two datasets, myds.Tables(0) and UmbrellaFromExcelDataSet.CancelTemplate . I've updated the UmbrellaFromExcelDataSet.CancelTemplate using data from myds.Tables(0) and now I want to put that data update into the database that it orignally came from.
The database isn't updating though.
My code is as follows:
Me.UmbrellaFromExcelDataSet.CancelTemplate.AcceptChanges()
Dim csvRow As DataRow
Dim dbRow As DataRow
Dim csvURNstring As String
Dim csvURNnumber As String
If finalVersion = True Then
For Each csvRow In myds.Tables(0).Rows
For Each dbRow In UmbrellaFromExcelDataSet.CancelTemplate.Rows
csvURNstring = csvRow.Item("URN").ToString
csvURNnumber = csvURNstring.Substring(3, 6)
If csvURNnumber = dbRow.Item("URN") Then
Me.CancelTemplateTableAdapter.Update(dbRow)
Exit For
End If
Next
Next
End If
Am I missing something?
Thanks in advance for any help offered.