Database dataset from updating

02-Dec-2017 08:51

The Data Set instance is the Data Set that contains the changes that have been made, and the Data Table identifies the table from which to retrieve the changes.

Generally we used Data Set for having the collection of Data.

Tables(0) and now I want to put that data update into the database that it orignally came from.

Accept Changes() Dim csv Row As Data Row Dim db Row As Data Row Dim csv URNstring As String Dim csv URNnumber As String If final Version = True Then For Each csv Row In myds. Rows For Each db Row In Umbrella From Excel Data Set.

When you concatenating two sql strings, you better add space at the end of first string or at the beginning of second string.

As Gordon Linoff pointed out your sql statement is incorrect.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions.