data adapter

This tutorial is part of Database Programming Made Easy Series.

[inline:textbox control using datasets and data adapters.jpg=TextBox Control using Datasets and Data Adapters]

In this tutorial you'll learn how to retrieve and save data back to the database using Datasets and Data Adapters.

Microsoft Access database and Microsoft SQL Server sample is provided.

This tutorial is part of Database Programming Made Easy Series.

[inline:Modify Data Using DataSet.jpg=Modify Data using Dataset and Data Adapter]

As I have mentioned in the previous tutorial on “How to Retrieve Data Using Data Readers”, I emphasized that if you want to just simply read data from the database you need to open it using data readers.

This tutorial is part of Database Programming Made Easy Series.

Retrieving data in Visual Basic .NET is now become easy compare to VB 6.0. In VB .NET you will have the privileged of modifying a data in offline mode.

The purpose for this is to eliminate for resources from the server. If you are thinking about concurrency, then you don’t have to worry because it is the work of Data Adapter to resolve problem with multiple users accessing the same row(s).

This tutorial is part of Database Programming Made Easy Series.

Before, I'm even wondering how to modify data in Visual Basic .NET especially if you used to work with Visual Basic 6.0. Although, there are slight difference with the two versions but I found .NET more interesting compare to VB 6.0.

This tutorial is part of Database Programming Made Easy Series.

[inline:DataSet and Data Adapter.jpg=Retrieve Data Using Retrieve Data Using DataSets and Data Adapters]

Dataset can be either connected to or disconnected from data sources. Data is save back to the database by using Data Adapters. Data Adapters handles the connection between Data Sources and Dataset