ADO.NET by Example
This course provides a complete look at ADO.NET Disconnected Model and Connection Oriented Model with multiple demos for understanding ADO.NET for beginners. By the end of the course, even a beginner can develop efficient applications to interact with any database from Windows forms and ASP.NET Web Applications.
What you'll learn
This course is targeted to beginners and will increase their understanding of ADO.NET and its use for interacting with any database or XML documents in an efficient and easy methodology. This course begins with a complete overview of ADO.NET Architecture, both Disconnected Model and Connection Oriented Mode, and subsequent modules will provide complete demos on ADO.NET Disconnected Model, Connection Oriented Model, Implementing 3-Tier Arch, Transaction Management, Concurrency Management, and also deals with performance issues. All demos will be developed using Visual Studio using C#.
Table of contents
- Introduction 2m
- Inserting a Record 5m
- Retrieving the Data 2m
- Finding the Datarow 3m
- Updating a Record 4m
- Removing a Record 3m
- Reading Data from Excel Sheets 4m
- Reading Data from XML Documents 3m
- Demo: Generating a Typed Dataset 2m
- Demo: Using Typed DataSet 3m
- Understanding Data Relations 1m
- Demo: Creating Master-details Applications Using Code 4m
- Demo: Creating Master-details Applications Using Typed Dataset 3m
- Finding the Record Using Dataview 3m
- Filtering the Data Using Dataview 2m
- Summary 1m
- Introduction 3m
- Understanding Transaction Management 2m
- To Do: Implementing 3-tier Architecture 2m
- Creating the Class Library 4m
- Creating a Windows Forms Application to Consume the Class Library 2m
- Registering the Class Library with the GAC 3m
- Consuming the Class Library from ASP.NET Web Site 2m
- Summary 1m
About the author
Sekhar Srinivasan (Microsoft Certified Trainer) is well known for his good track record as one of the best I.T. faculty in imparting his unique techniques in training for the past 19 years. He's trained students on various Microsoft Technologies Platforms, including VB6.0, ASP, VB.NET, C#, ASP.NET, Silverlight, ASP.NET MVC, SharePoint 2013, Azure, Xamarin.Andriod, Xamarin.iOS, Xamarin Forms, and JavaScript Frameworks. Sekhar has rich experience in technology consulting, providing solutions for c... more