ADO.NET Training

ADO.NET provides a bridge between the front end controls and the back end database. The ADO.NET objects encapsulate all the data access operations and the controls interact with these objects to display data, thus hiding the details of movement of data.


Course Detail

  • Visual Studio .NET
  • OLEDB and SQLServer
  • Namespaces and Classes
  • Interfaces
  • First ADO.NET Program.
  • Managed Providers
  • Connection Class
  • Connection Strings
  • Connection Pooling
  • Connection Events
  • Connection Factory Pattern
  • Error Handling
  • Command Objects
  • Command Types
  • Result Sets
  • Running queries
  • Running scalar queries
  • Running nonqueries
  • Parameters
  • Practical Assighnment-1
  • Notes-1
  • DataReader Classes
  • Retrieving Data
  • Updating Data
  • Practical Assighnment-2
  • Notes-2
  • DataSet
  • DataAdapter
  • Command Objects
  • DataTable
  • DataColumn
  • DataRow
  • Editing Columns
  • Row States and Versions
  • Sorting and Searching DataTables
  • Events
  • Practical Assighnment-3
  • Notes-3
  • Concurrency Overview
  • Transaction
  • Transaction and DataAdapter
  • Isolation Levels
  • Practical Assighnment-4
  • Notes-4
  • Strong coupling between ADO.NET and XML
  • Typed DataSet
  • Rendering XML from a DataSet
  • Reading XML into a DataSet
  • Synchronized DataSet
  • Practical Assighnment-5
  • Notes-5
  • DataView
  • Data Binding in Windows Forms
  • Simple Data Binding
  • DataGrid Binding
  • Master Detail Binding
  • Data Binding in Web Forms
  • Practical Assighnment-6
  • Notes-6
  • DataView
  • Data Binding in Windows Forms
  • Simple Data Binding
  • DataGrid Binding
  • Master Detail Binding
  • Data Binding in Web Forms
  • Practical Assighnment-6
  • Notes-6
ADO.NET Training