MS ADO.NET

ADO.NET Overview

Setting Up Your Environment

Connect to A Data Source Using ADO.NET

Setup and Connecting with WinForm

SqlConnectionStringBuilder

Retrieving Data from A Data Source

Build SQL Statement

Implement Data Layer

Design Winform Application

Store Procedure call via ADO.NET

Inserting, Deleting, Updating Data from A Data Source

Prepare Execute Non Query

Creating Stored Procedure

Inserts With Execute Scalar

Using Output parameter

Using Return Value parameter

Delete information from DB via Execute Non Query

Updates with Execute Non Query

Understanding Errors with ADO.NET

Catch SQL Exception Errors

Note:  Change the Date source which does not exist.

Use Raise Error

Using SQL Data Adapter

Load A Data Table via SQL Adapter

Bind the Data Table

Update with SQL Adapter

Client Side Performance Tracking

Setup Client Statistics

Retrieve Statistics

Display All statistics

Round Trips

Managing Concurrency and Transactions

Concurrency checkings with WHERE Clause

Concurrency checking with SQL Adapter

Concurrency checking with Time Stamp

SQL Transaction

Transaction Scope

Note: If you make different DB server calls in this transaction scope that is called as DTC.

Server Transaction

Connection Pooling

SQL Server Profiler and Pooling

Performance Monitor and Pooling

Using XML with ADO.NET

Writing XML into DB

Reading XML from DB

Blogger Labels: Fundamentals,Overview,Environment,Connect,Data,Source,Setup,WinForm,SqlConnectionStringBuilder,Build,Statement,Implement,Layer,Design,Application,Procedure,Prepare,Execute,Query,Inserts,Scalar,Output,parameter,Return,Value,Delete,information,Updates,Errors,Catch,Exception,Note,Change,Date,Raise,Error,Adapter,Load,Table,Bind,Update,Client,Side,Performance,Statistics,Retrieve,Display,Round,Trips,Concurrency,Transactions,WHERE,Clause,Time,Stamp,Transaction,Scope,server,Connection,Profiler,Monitor