Hi Tony,
It is possible. But you have to reassign the select,insert,update and delete commands to the data Adapter each time.
the code should be something like this
Imports System.Data.SqlClient
Public Class Form1
Dim ds As DataSet
Dim adp As SqlDataAdapter
Dim con As SqlConnection
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
For Each tbl As DataTable In ds.Tables
adp = New SqlDataAdapter
If tbl.TableName = "TransferMaster" Then
adp.SelectCommand = New SqlCommand("your select command", con)
adp.InsertCommand = New SqlCommand("Your insert command", con)
adp.UpdateCommand = New SqlCommand("Your update command", con)
adp.DeleteCommand = New SqlCommand("Your delete command", con)
ElseIf tbl.TableName = "TransferDetail" Then
adp.SelectCommand = New SqlCommand("your select command", con)
adp.InsertCommand = New SqlCommand("Your insert command", con)
adp.UpdateCommand = New SqlCommand("Your update command", con)
adp.DeleteCommand = New SqlCommand("Your delete command", con)
End If
adp.Update(tbl)
Next
End Sub
End Class