Overloads Public Shared Sub UpdateTable( _
   ByVal updatingDataset As DataSet, _
   ByVal connection As DbConnection, _
   ByVal transaction As DbTransaction, _
   ByVal dataAdapter As DbDataAdapter, _
   ByVal cmdBuilder As DbCommandBuilder, _
   ByVal tableName As String, _
   ByVal ignoreConcurrencyExceptions As Boolean, _
   ByVal supportInsert As Boolean, _
   ByVal supportUpdate As Boolean, _
   ByVal supportDelete As Boolean _
) 

Visual Basic (Usage)

Copy Code

Dim updatingDataset As DataSet Dim connection As DbConnection Dim transaction As DbTransaction Dim dataAdapter As DbDataAdapter Dim cmdBuilder As DbCommandBuilder Dim tableName As String Dim ignoreConcurrencyExceptions As Boolean Dim supportInsert As Boolean Dim supportUpdate As Boolean Dim supportDelete As Boolean   SqlProviderUtilities.UpdateTable(updatingDataset, connection, transaction, dataAdapter, cmdBuilder, tableName, ignoreConcurrencyExceptions, supportInsert, supportUpdate, supportDelete)

public static void UpdateTable( 
   DataSet updatingDataset,
   DbConnection connection,
   DbTransaction transaction,
   DbDataAdapter dataAdapter,
   DbCommandBuilder cmdBuilder,
   string tableName,
   bool ignoreConcurrencyExceptions,
   bool supportInsert,
   bool supportUpdate,
   bool supportDelete
)

public:
static void UpdateTable( 
   DataSet^ updatingDataset,
   DbConnection^ connection,
   DbTransaction^ transaction,
   DbDataAdapter^ dataAdapter,
   DbCommandBuilder^ cmdBuilder,
   String^ tableName,
   bool ignoreConcurrencyExceptions,
   bool supportInsert,
   bool supportUpdate,
   bool supportDelete
) 

Parameters

updatingDataset

The System.Data.DataSet which contains the System.Data.DataTable to update.

connection

The System.Data.Common.DbConnection to use to connect to the database.

transaction

The System.Data.Common.DbTransaction to use when updating the changes into the database.

dataAdapter

The System.Data.Common.DbDataAdapter which corresponds to the same type of the database provider.

cmdBuilder

The System.Data.Common.DbCommandBuilder to be used for building the Insert, Update and Delete commands.

tableName

The name of the System.Data.DataTable which will be updated into the database.

ignoreConcurrencyExceptions

true to ignore System.Data.DBConcurrencyException exceptions while updating the database and continue the update.

supportInsert

true to create an Insert command which will insert all the new rows in the referenced System.Data.DataTable.

supportUpdate

true to create an Update command which will update all the modified rows in the referenced System.Data.DataTable.

supportDelete

true to create a Delete command which will delete all the removed rows in the referenced System.Data.DataTable.

Target Platforms: Microsoft .NET Framework 2.0, Windows 2000, Windows XP, Windows Server 2003 family, Windows Server 2008 family, Windows Vista, Windows 7

Reference