ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data. ADO.NET cleanly factors data access from data manipulation into discrete components that can be used separately, or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results can be presented to the database users in any number of ways. In this tutorial, Mark Long shows you, step by step, how to take advantage of ADO.NET’s functionality to enhance your network’s productivity. To get started today, simply click one of the movie topics below.
Creating Stored Procedures with Parameters
Passing Parameters to Stored Processes
Multiple Result Sets in a DataReader
Reading Schema from a DataReader
Inserting Data with CommandBuilder pt. 1
Inserting Data with CommandBuilder pt. 2
Updating Data with CommandBuilder
Deleting Data with CommandBuilder
Navigating with Binding Objects pt. 1
Navigating with Binding Objects pt. 2
Navigating with Collections pt. 1
Navigating with Collections pt. 2
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.