Chapter 11. Making External Data Available Locally

After completing this chapter, you will be able to:

  • Load external data into a DataTable or DataSet

  • Return updated DataSet content to an external source

  • Use SQL statements and stored procedures to manage DataSet content

The disconnected data experience provided by ADO.NET revolves around the DataSet class and its supporting objects. The last few chapters have introduced ways to access external data with ADO.NET, but none of those features took advantage of the disconnected aspects of the framework. Still, part of the promise of ADO.NET is its ability to manage external data in a disconnected and table-focused way.

This chapter introduces the DataAdapter class—the class that fulfills that core data promise. ...

Get Microsoft® ADO.NET 4 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.