Chapter 6 : Working with Data in a Connected Environment

Lesson 0: Connected & Disconnectd Environment in ADO.NET Lesson 1: Creating and Executing Command Objects Lesson 2: Working with Parameters in SQL Commands
Note: Lesson 3: BLOBs and Lesson 4: Bulk Copy: For reading at home Lesson 5: Performing Transactions by Using the Transaction Object
VB.Net 2005 - Chapter 6 2

1

Lesson 0: Connected & Disconnectd Environment in ADO.NET
2 ways using with ADO.NET
Data Source Web Form Connection Data Adapter DataSet Windows Form

Disconnectd

Connected
Data Source Web Form Connection Command DataReader Windows Form
VB.Net 2005 - Chapter 6 3

Disconnected Data Access
Advantages Disadvantages
Expensive when open, close connections Retrieving large result sets can be very slow Places demand on client memory and CPU
Single database server can support many users reduced server's resources Data using more flexible Data not 'tied' to a connection easy to pass

ERROR:connection to 10.20.1.101:9315 failed (errno=111, msg=Connection refused)