Developing ADO'NET

1
Developing ADO.NET Applications for SQL Server
Course Content ADO.NET TECHNOLOGY
OVERVIEW Defining data-centric applications
Connected and disconnected classes Relating
ADO.NET to multitier architectures THE ADO.NET
ENVIRONMENT Visual database tools Visual Studio
2005 /SQL Server 2005 /Server Explorer /Query
Designer The distributed application
architecture System.Data namespace ADO.NET
2.0 object model Connected and unconnected
classes .NET managed data providers Vendor-neut
ral ,Vendor-specific and SQL Server data provider
libraries BUILDING APPLICATIONS WITH THE
CONNECTED MODEL Establishing a connection Buildi
ng connection strings Authenticating users
Managing connection pooling Executing
commands Attaching command objects to a
connection Executing SQL queries with the
Execute Reader method Asynchronous commands
Processing SQL Server data Extracting data
using Get methods Executing batch SQL multiple
statements Multiple Active Results Sets (MARS)
on a single connection Modifying data
consistently Updating, inserting and deleting
data Passing SQL statements with Execute Non
Query Maximizing performance with stored
procedures Creating Transact-SQL stored
procedures Adding input and output parameters
Returning values from stored
procedures Handling exceptions The
DataException class Trapping provider-specific
exceptions SqlException /SqlError
Code B124 Duration 24 Hrs.(4 Days) (
09.00-16.30 ) Level Intermediate Skills
Gained Build ADO.NET 2.0 applications for SQL
Server 2005 Maximize performance using
ADO.NET's connected model Read and process
data from SQL Server and XML sources Retrieve
and modify disconnected data Ensure data
consistency with transactions and exception
handling Exploit the powerful data-binding
capabilities of ADO.NET Who should attend
This course is valuable for database
developers, programmers, software engineers and
system architects. Familiarity with an
object-oriented programming language is assumed.
Experience with SQL is helpful.
RETURNING DISCONNECTED DATA Working with XML
data Constructing Data Tables Populating a
Data Table with XML Manipulating client-side
data Data Rows Data Columns Filtering
data with the Select method Building
expressions Data Sets and Data
Adapters Configuring Data Adapters Filling a
Data Set using a Data Adapter Joining Data
Tables using relations Adding constraints to
Data Sets XML and XML Schemas The Visual XSD
Editor Generating Typed Data Sets MODIFYING
DISCONNECTED DATA Updating Data Rows Detecting
changes Enforcing business rules Accepting
and rejecting changes Persisting changes to SQL
Server Data Adapter and its command objects
The Data Adapter Configuration Wizard
Command Builder pros and cons Controlling
transactions Locking data The Transaction
class Implementing optimistic concurrency
Selecting transaction type ADO.NET or SQL
Server DATA BINDING Binding Windows
Forms Simple and complex binding The Data
View and Currency Manager Raising data errors
in Data Sets ASP.NET Web Form controls Binding
to single properties and arrays Complex
binding to Web Form controls Templates
Binding expressions
???????????????????????????????????????????????
??????????????????????????????????????????????
??? http//www.ccp.or.th