Friday, May 29, 2015

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

No comments:

Post a Comment