Example OleUpdate:

       We need to update records into a data source. How can we complete it using OLEDB? Yes! It is easy!

1. How to open a connection through OLEDB/ODBC.
2. How to add a record into a table.
3. How to delete a record from a table.
4. How to update a record into a table.
5. How to use different ways to set length and status for a field.

        In addition to use of a rowset, you can use a simple SQL statement, a parameterized statement, parameterized stored procedure or a provider-specific interface to update data into a data source. These methods may be better than use of a rowset in many cases. Here are good examples, MultiProcs, FastLoad, MkTbls and BLOBs.