Summary

This chapter presents coding techniques for typical tasks you might perform with ADO.NET. It starts by drilling down on OleDbConnection objects. In particular, the chapter contrasts connection strings in Access databases with those in SQL Server. Then, we discuss OleDbCommand objects for dynamic data access. In addition, you learn how to wrap data manipulation queries in transactions. The chapter closes with an in-depth look at performing data manipulation with data adapters and datasets. You see how to set up a data adapter for filling a dataset and handling inserts , deletes, and updates. The chapter also contrasts code-based datasets with graphically generated ones. The final sample illustrates how to handle concurrency conflicts that can occur when two datasets make conflicting changes to an Access database.

 


Programming Microsoft Visual Basic. NET for Microsoft Access Databases
Programming Microsoft Visual Basic .NET for Microsoft Access Databases (Pro Developer)
ISBN: 0735618194
EAN: 2147483647
Year: 2006
Pages: 111
Authors: Rick Dobson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net