SqlDataAdapter provides the communication between the Dataset and the Data Source with the help of SqlConnection Object . TheSqlConnection Object has no information about the data it retrieves . Similarly a Dataset has no knowledge of the Data Source where the data coming from. So the SqlDataAdapter manage the communication between these two Objects.

The SqlDataAdapter object allows us to populate Data Tables in a DataSet. We can use Fill method of the SqlDataAdapter for populating data in a Dataset. The following source code shows a simple program that uses SqlDataAdapter to retrieve data from Data Source with the help of SqlConnection object and populate the data in a Dataset.

Imports System.Data.SqlClient Public Class Form1     Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click         Dim connetionString As String         Dim connection As SqlConnection         Dim adapter As SqlDataAdapter         Dim ds As New DataSet         Dim i As Integer   connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"         connection = New SqlConnection(connetionString)         Try             connection.Open()             adapter = New SqlDataAdapter("Your SQL Statement Here", connection)             adapter.Fill(ds)             connection.Close()             For i = 0 To ds.Tables(0).Rows.Count - 1                 MsgBox(ds.Tables(0).Rows(i).Item(1))             Next         Catch ex As Exception             MsgBox(ex.ToString)         End Try     End Sub End Class