ADO NET Connections and Commands

To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design

Good knowledge of VB.NET, SQL, relational databases, and Visual Studio .NET

Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths

WEB

Distributed data-access requirements| - describe the features required of a distributed or disconnected data-access system tuned for web services and web applications.|Architecture of ADO.NET| - describe the broad architecture of ADO.NET, set out its object model, and list its main objects.|Defining an ADO.NET Connection object in VB.NET| - choose between the different .NET data providers and create a connection string.|Working with ADO.NET connections in VB.NET| - open and close connections to data sources, handle connection events, and deal with exceptions.|Pooling ADO.NET connections in VB.NET| - explain why connection pooling is necessary and describe how to pool connections.|Creating ADO.NET connections in VB.NET| - select appropriate connection properties in a connection string, handle connection events, and manage connection pools.|Creating stored procedures in Visual Studio .NET| - describe how to create and use stored procedures and parameters in Visual Studio.NET and ADO.NET.|Managing stored-procedure parameters in VB.NET| - describe how to set input parameters and access return values and output parameters in stored procedures.|Coding for stored procedures in VB.NET| - call stored procedures using command objects and define input and output parameters for them.|Connected data access| - describe the reasons for direct database access and how this is performed in ADO.NET.|Executing ADO.NET Command objects in VB.NET| - explain how to execute Command objects for returning no values, single values, or to run DDL and DML commands.|ADO.NET DataReaders using VB.NET| - explain how to process rows of read-only data from a data source.|Using ADO.NET Commands and DataReaders with VB.NET| - process rows of data from a DataReader and extract metadata about rows.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...