ADO.NET With C Sharp (Index)

ADO.NET With C# Course Structure

ADO.NET Basics

• Connection, DataAdapter and DataSet
• SqlConnection vs. OleDbConnection
• Connection Pooling
• Transaction within a Database
• Create an Assembly with Strong Name
• Storing Binary Data in SQL Server Database

ADO DATA OBJECTS

• DataReader
• Accessing a Cell in a DataRow
• Different Versions of Cell Data
• DataRow.IsNull
• Expression Column
• DataView
• Filtering DataRows with Enumeration DataViewRowState
• HasErrors Method of a DataSet & DataRow
• Creating a New DataRow
• Finding a DataRow by Primary Key

DATA BINDING

• Binding a Property of a Control to a DataTable Column
• CurrencyManager
• Binding Data Source to Controls on a Child Form
• ListControl’s Data Binding
• Customizing Data Flow between the Control and its Data Source

Dataset Schema

• By default , minimum schema is filled into dataset by DataAdapter.Fill
• How to Create a Dataset with Schema
• ForeignKeyConstraint vs. DataRelation
• Turning Off Contraints before Fill
• Navigating Between Tables with DataRelations
• Do Not Join Database Tables in DataSet
• Schema Table
• Mapping Table Names in DataAdapter.Fill
• Mapping column names in DataAdapter.Fill
• Strongly Typed DataSet
• Challenges Brought By Using Strongly Typed DataSet
• How are Column Constraints Represented in Strongly Typed DataSet

UPDATING DATABASE

• RowState, AcceptChanges and RejectChanges
• Submitting Changes with Ad hoc Queries or Stored Procedures
• Accommadating NULL Values When Updating
• Concurrency Control with Time Stamp
• Refreshing DataSet After Submitting Changes
• Retrieving Auto-generated Identity (SQL Server)
• SET NOCOUNT ON/OFF
• DataSet.Merge
• When there is a Separate Data Access Tier
• Oracle's sequence object – Counterpart of SQL auto-increment
• Solving Concurrency Conflict
• Transaction Management

ADO.NET & XML

• DataSet’s Support of XML
• XmlReader
• XmlDocument & XmlNode
• XmlDataDocument
• XPath
• XmlReader & SQL Server 2000’s Support on XML
• SQL XML .NET Data Provider

DATA BINDING

• Binding a Property of a Control to a DataTable Column
• CurrencyManager
• Binding Data Source to Controls on a Child Form
• ListControl’s Data Binding
• Customizing Data Flow between the Control and its Data Source