ADO NET Tutorial: (25 Hours) ADO.NET Step By Step Video Tutorial

Posted by asp.net videos on Tuesday, September 30, 2008 · Leave a Comment 

"I tried to learn .NET by taking boot camp classes that cost me $6,000. After taking the classes, I discovered tons of free (and very cheap) videos on the internet created by experts in the field. I found the videos to be much better than the classrooms. The videos were presented by Microsoft presenters that knew the material backwards and forwards, and they were much cheaper and better than the classroom teachers. I have spent the last three years organizing and hunting down the videos for my own use and decided that all could benefit by sharing what I found." - Wade Harvey

Click Here for Free 24 hour pass to lynda.com.

I AM VERY EXCITED ABOUT THIS AMAZING NEW DISCOVERY

Over 40,000 Top-Notch Video Tutorials (or 3,452 hours) on Lynda.com

I had stumbled across Lynda.com many times before, but never stopped to try it out. I recently took the plunge and started using Lynda.com to help me improve my javascript skills (See Javascript Essential Training 2007 by Dori Smith). It has revolutionized my understanding of the language! I love the fact that the exercise files allow you to follow along in real time with what the instructor is saying. Learning by doing is an extremely powerful technique. I have to give the site an A+ for both quality and content.

I am planning on using Lynda Videos to help me improve in:

  1. HTML
  2. CSS
  3. Classic ASP
  4. .NET (included in ASP section)
  5. AJAX
  6. Silverlight (in Microsoft Section)
  7. SharePoint (in Microsoft Section)
  8. Web Design
  9. Blogging
  10. SEO
  11. and much more
You can learn more about Lynda.com by watching the 5-minute video at About Lynda.com. If you are only focusing on .NET, you are missing out on the "big picture" and on many of the underlying fundamentals! To be an Ideal Programmer, you need to have the largest knowledge base possible.

JavaScript tutorials



Looking for premium .NET Training Videos? The best premium .NET Videos that I have found are at Learn Visual Studio. Those videos are only about 50 cents per hour, as compared to $25 per hour that other sites charge!

LearnVisualStudio is currently having a 25% off sale ($50 savings) and giving away a free membership to TrainingSpot ($60 value) when LVS Lifetime Membership is purchased.

  

DiscountASP .NET hosting  JavaScript tutorials


Limited Time Offer: Free Lifetime Membership to Progress Monitor ($24.95 value) when you purchase any membership at Learn Visual Studio, Lynda Videos or any hosting account at DiscountASP - just forward order confirmation to harvey007@sbcglobal.net

My Microsoft MVP Award (2009) - ado.net, net data provider, ado net tutorial, c# ado net, net postgresql, ado net dataset, ado provider<br /> Microsoft's Lindsay Rutter and Glen Gordon present 25 hours of data access fundamentals for dotNET programmers. Here are just a few of the topics covered in this video series: , , , ado net dataset, ado provider, and more.
Creative Commons License photo credit: Mendhak
 

ADO.NET Step By Step

 

1. Getting Started
Key Concepts:

A. Overview of ADO.NET, the data-access component of the Microsoft .NET Framework
B. How ADO.NET works with almost any component on nearly every platform that understands XML.

5/9/2007 Duration: 63 minutes
2. Creating Connections
Key Concepts:

A. Creating Connections
B. Connection Properites
C. Methods for manipulating connections
D. Handling events raised by connections

5/16/2007 Duration: 53 minutes
3. Data Commands and Data Reader
Key Concepts:

A. DataReaderallows one to retrieve recordsets from databases
B. How to manipulate the data with commands (Select, Update, Delete, Insert)

5/23/2007 Duration: 65 minutes
4. The Data Adapter
Key Concepts:

A. How the DataAdapter facilitates the communication between the DataSet and the database. B. How the DataSet provides methods to select, insert, update, and delete data

5/30/2007 Duration: 64 minutes
5. Transaction Processing
Key Concepts:

A. Create a transaction
B. Create a nested transaction
C. Commit transactions
D. Rollback transactions

6/06/07 Duration: 53 minutes
6. Modeling a Database using Datasets and DataRelations
Key Concepts:

A. Create DataSets
B. Add DataTables and DataRelations to DataSets
C. How to clone and copy DataSets.

6/13/2007 Duration: 57 minutes
7. Using DataTables
Key Concepts:

A. Structure of DataTables
B. Properties of DataTables
C. Methods of DataTables.

6/20/2007 Duration: 58 minutes
8. Using TableAdapters
Key Concepts:

A. How to build a TableAdapter class and a TableAdapter object, and how to configure them.

6/27/2007 Duration: 59 minutes
9. Using Dataviews
Key Concepts:

A. How the DataView can help you filter and sort DataRows at design time
B. How you can add a DataView to a form

7/05/2007 Duration: 55 minutes
10. Editing and Updating Data
Key Concepts:

A. Editing and updating data using DataViews, TableAdapters, DataTables, and DataSets.

7/11/2007 Duration: 65 minutes
11. Data-Binding in Windows Forms with the BindingSource Class
Key Concepts:

A. Bind data to your Windows Forms
B. How to bind controls to ADO.NET data sources.
C.BindingSource class, new in ADO.NET version 2.0, which acts as an intermediary between a data source and Windows Forms controls to simplify and extend the data-binding process.

7/18/2007 Duration: 66 minutes
12. Using ADO.NET in Windows Forms
Key Concepts:

A. Binding data to format it
B. Displaying bound data
C. Data-Binding events

7/25/2007 Duration: 63 minutes
13. Basic Data Binding in Web Forms using the Data Source Component
Key Concepts:

A. Binding data in Microsoft ASP.NET and Web Forms with ADO.NET objects
B. Data source controls, new to the Microsoft .NET Framework version 2.0, that enable data binding with very little code.

8/1/2007 Duration: 65 minutes
14. Data-Bound and Validation Controls
Key Concepts:

A. The data-bound Web Form controls that are designed to work with the Microsoft .NET version 2.0 data source controls that also work with ADO.NET objects.

8/08/2007 Duration: 63 minutes
15. Reading and Writing XML and the XMLDataDocument
Key Concepts:

A. Interaction between ADO.NET and XML.
B. Structure of an XML schema and the DataSet methods that enable us to read and write data from an XML data stream.
C. The XmlDataDocument that provides an XML view of the data in a DataSet.

9/05/2007 Duration: 70 minutes
16. Using ADO and ADOX in the .Net Framework
Key Concepts:

A. Some real-world uses of ADO.NET.
B. How you can work with data objects created with previous versions of ActiveX Data Objects (ADO)
C. Microsoft ActiveX Data Objects Extensions for Data Definition Language (DDL) and Security (ADOX) library.

8/22/2007 Duration: 55 minutes

 

Related posts:

  1. ADO.NET – Over 3 Hours of Premium Video Tutorials Here is a collection of over 3 hours of premium...
  2. 24 Hours of SQL Server 2008 – A Video Tutorial presented by Microsoft Experts 24 hours of free video tutorials on using SQL Server...
  3. Windows Presentation Foundation-18 Hours of Free Video Tutorials Windows Presentation Foundation - 18 hours of free video tutorial...
  4. SQL Server 2005:(10 Hours) Backup SQL Server 2005, SQL Server Insert, SQL Server Training, SQL Server Profiler, Download SQL Server 2005, SQL Server Script, SQL Server Tutorial 10 Free One-Hour Videos From Microsoft Expert, Bryan Von Axelson....
  5. Windows Communication Foundation – 15 Hours of Free Video Tutorials 15 FREE one-hour video tutorials on Windows Communication Foundation by...

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under Videos, Visual Basic & VB.NET · Tagged with , , , , , , , , ,

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

This blog uses the cross-linker plugin developed by Web-Developers.Net

http://idealprogrammer.com/home/idearcom/public_html/wp-content/plugins/wp-super-cache/