Visual Basic 2015 Unleashed

Summary

ADO.NET is the .NET Framework area providing the data access infrastructure for data access. With ADO.NET, you access data in two modes: connected and disconnected. For the connected mode, you create Connection objects to establish a connection, Command objects to send SQL query strings to the data source, and DataReader for fetching data; finally, you close the Connection object. In a disconnected environment, you take advantage of DataSets that are in-memory representations of databases and where each table is a DataTable object, each record is a DataRow object, and TableAdapter objects act like a bridge between the database and the DataSet. You perform CRUD operations invoking the Add, Delete, Update, and New methods of DataTable ...