Command Builder
When we view the dataset in Part 2, you'll see why this is useful (and I
recommend it for all of your dataset updating needs). Basically when you make
a change in the dataset and want to update the data source you can use one of
these to generate the SQL all for you.
Dim
objCmdBld As New OleDbCommandBuilder(objAdapter) |
From there on its automatic, you can update a data source with this command
alone
objAdapter.Update(ds, "users") |
and it will update fine.
You'll find out more
about this in Part 2.
What we haven't gone over
here is the use of the very few others and we haven't gone over the SQL Server
ones. The others are for more advanced functions and can be left till later
and then SQL Server ones are basically the same (Replace OleDb with SQL and
the namespaces are a bit different).