
Microsoft ADO.NET
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.
Course content
Course Introduction4 lessons
Overview of ADO.NET3 lessons
ADO.NET Objects2 lessons
Connecting To A Database9 lessons
- Opening A Database Connection3:131 credit or ad
- Using Error Handling4:551 credit or ad
- Connection Status4:021 credit or ad
- Using Trusted Security4:551 credit or ad
- Connection String Variables4:161 credit or ad
- Connecting to Access4:121 credit or ad
- Using UDL Files5:041 credit or ad
- Provider Gotchas3:021 credit or ad
- Connection Miscellaneous6:081 credit or ad
Executing Commands5 lessons
Using Stored Procedures7 lessons
- What is a Stored Procedure?3:441 credit or ad
- Creating Stored Procedures4:381 credit or ad
- Calling Stored Procedures4:041 credit or ad
- Creating Stored Procedures with Parameters3:531 credit or ad
- Passing Parameters to Stored Processes4:211 credit or ad
- Transactions pt. 14:141 credit or ad
- Transactions pt. 23:251 credit or ad
DataReader4 lessons
DataAdapter6 lessons
DataSet7 lessons
Data Binding8 lessons
- What is Data Binding?2:591 credit or ad
- Data Bound Textboxes4:491 credit or ad
- Life without Cursors2:391 credit or ad
- Navigating with Binding Objects pt. 14:101 credit or ad
- Navigating with Binding Objects pt. 25:311 credit or ad
- Navigating with Collections pt. 15:201 credit or ad
- Navigating with Collections pt. 23:321 credit or ad
- Complex Binding7:081 credit or ad