A
astro
I would like to build some generic code that is able to figure out the
correct dataAdapter to apply changes to given a form with several
dataAdapters.
Any suggestions on the following?
Thank you.
======================================
Private Sub SaveChanges(ByVal aContainer As Object)
Dim dt As DataTable
Dim ds As New DataSet
Dim bSaveMe As Boolean
Dim myDA As System.Data.SqlClient.SqlDataAdapter
For Each dt In Me.DS1.Tables
If Not dt.GetChanges(DataRowState.Modified) Is Nothing Then
bSaveMe = True
End If
If bSaveMe Then
ds.Merge(dt.Select("", "",
DataViewRowState.ModifiedCurrent))
myDA = <<<<< figure out correct dataAdapter
here>>>>>> <<<=====NEED SUGGESTION HERE
myDA.Update(ds)
End If
bSaveMe = False
Next
Exit Sub
End Sub
======================================
correct dataAdapter to apply changes to given a form with several
dataAdapters.
Any suggestions on the following?
Thank you.
======================================
Private Sub SaveChanges(ByVal aContainer As Object)
Dim dt As DataTable
Dim ds As New DataSet
Dim bSaveMe As Boolean
Dim myDA As System.Data.SqlClient.SqlDataAdapter
For Each dt In Me.DS1.Tables
If Not dt.GetChanges(DataRowState.Modified) Is Nothing Then
bSaveMe = True
End If
If bSaveMe Then
ds.Merge(dt.Select("", "",
DataViewRowState.ModifiedCurrent))
myDA = <<<<< figure out correct dataAdapter
here>>>>>> <<<=====NEED SUGGESTION HERE
myDA.Update(ds)
End If
bSaveMe = False
Next
Exit Sub
End Sub
======================================