Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog Blog

Workday HCM Demo New Batches Starting from Friday... 31-8-2018
Search Course Here

Live Chat
ADO.NET C# online training

ADO.NET C# 2010


ADO.NET is a group of libraries used to create powerful databases using various sources that include Microsoft SQL Server, Microsoft Access, Oracle, XML, etc. ADO.NET relies on the .NET Framework's various classes to process requests and perform the transition between a database system and the user. The operations are typically handled through the DataSet class.

While ADO.NET is the concept of creating and managing database systems, the DataSet class, as we have introduced it so far, serves as an intermediary between the database engine and the user interface, namely the Windows controls that the user uses to interact with the computer. Still, remember that a DataSet object is used to manage lists, any lists, not just those created using database environments such as Microsoft SQL Server or Microsoft Access.
  • All attendees should have a basic knowledge of SQL and of programming the .NET Framework using C#. Students should also understand the fundamentals of XML and be able to write simple Windows Forms applications. A working knowledge of SQL Server is desirable.
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction to ADO.NET
    • Microsoft Data Access Technologies
    • From ADO to ADO.NET
    • ADO.NET Architecture
    • Namespaces and Classes
    • Interfaces
    • DataSets and Disconnected Access
    • First ADO.NET Programs
    • Acme Computer Case Study
  • ADO.NET Connections
    • .NET Data Providers
    • IDbConnection
    • Connection Classes
    • Connection Strings
    • Connection Pooling
    • Connection Events
    • Error Handling
  • ADO.NET Commands
    • IDbCommand
    • Command Objects
    • Creating Commands
    • Executing Commands
    • Parameterized Queries
    • Command Types
    • Using Stored Procedures
    • Batch Queries
  • DataReaders and Connected Access
    • DataReaders
    • IDataReader
    • IDataRecord
    • Type-Safe Accessors
    • Null Columns
    • ExecuteReader Options
    • Multiple Result Sets
    • Obtaining Schema Information
  • Data Sets and Disconnected Access
    • DataSet
    • DataAdapter
    • Command Objects
    • DataTable
    • DataColumn
    • DataRow
    • Row States and Versions
    • Accept or Reject Changes
    • DataTable Events
    • Updating a Database from a DataSet
    • Command Builders
  • More About DataSets
    • Filtering DataTables
    • Multiple Table DataSets
    • Schema
    • Constraints
    • Relations
    • Navigating a DataSet
    • DataMapping
    • Creating a DataSet Programmatically
  • XML and ADO.NET
    • Strong Coupling Between ADO.NET and XML
    • Rendering XML from a DataSet
    • Controlling XML Output
    • Reading XML into a DataSet
    • XML Schema and DataSets
    • Typed DataSets
    • Table Adapters
    • Synchronizing DataSets and XML
    • XML Serialization
  • Concurrency and Transactions
    • DataSets and Concurrency
    • Optimistic Concurrency
    • Pessimistic Concurrency
    • Handling Concurrency Violations
    • ADO.NET Transactions
    • Database Transactions
  • Additional Features
    • Asynchronous Database Operations
    • Multiple Active Result Sets
    • Bulk Copy
  • LINQ and Entity Framework
    • Language Integrated Query (LINQ)
    • Bridging Objects and Data
    • Using Object Relational Designer
    • Filtering, Ordering and Aggregation
    • Inserts, Deletes and Updates
    • LINQ to SQL
    • LINQ to DataSet
    • ADO.NET Entity Framework
    • LINQ to Entities
  • Conclusion
ADO.NET C# 2010 Videos will be updated Soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Starting From 28th August & 29th August.

Hadoop Dev New Batch Starting From 28th August & 29th August.

IBM COGNOS TM New Batch Starting From 28th August & 29th August.

Informatica Dev New Batch Starting From 28th August & 29th August.

Mean Stack New Batch Starting From 28th August & 29th August.

SAP BODS new Batch Starting From 28th August & 29th August.

SAP S/4 HANA New Batch Starting From 28th August & 29th August.

Tableau New Batch Starting From 28th August & 29th August.


(1) Workday Technical Demo Training

Demo Schedule : 09:30 P.M EST / 08:30 P.M CST / 6:30 P.M PST on 23th August & 07:00 A.M IST on 24th August

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :