UpdateTable(DataSet,DbConnection,DbTransaction,DbDataAdapter,DbCommand,DbCommand,DbCommand,String,Boolean,Boolean,Boolean,Boolean) Method

public static void UpdateTable( 
   DataSet updatingDataset,
   DbConnection connection,
   DbTransaction transaction,
   DbDataAdapter dataAdapter,
   DbCommand insertCommand,
   DbCommand updateCommand,
   DbCommand deleteCommand,
   string tableName,
   bool ignoreConcurrencyExceptions,
   bool supportInsert,
   bool supportUpdate,
   bool supportDelete
)

'Declaration
 
Public Overloads Shared Sub UpdateTable( _
   ByVal updatingDataset As DataSet, _
   ByVal connection As DbConnection, _
   ByVal transaction As DbTransaction, _
   ByVal dataAdapter As DbDataAdapter, _
   ByVal insertCommand As DbCommand, _
   ByVal updateCommand As DbCommand, _
   ByVal deleteCommand As DbCommand, _
   ByVal tableName As String, _
   ByVal ignoreConcurrencyExceptions As Boolean, _
   ByVal supportInsert As Boolean, _
   ByVal supportUpdate As Boolean, _
   ByVal supportDelete As Boolean _
) 

'Usage
 
Dim updatingDataset As DataSet
Dim connection As DbConnection
Dim transaction As DbTransaction
Dim dataAdapter As DbDataAdapter
Dim insertCommand As DbCommand
Dim updateCommand As DbCommand
Dim deleteCommand As DbCommand
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, insertCommand, updateCommand, deleteCommand, tableName, ignoreConcurrencyExceptions, supportInsert, supportUpdate, supportDelete)

public static void UpdateTable( 
   DataSet updatingDataset,
   DbConnection connection,
   DbTransaction transaction,
   DbDataAdapter dataAdapter,
   DbCommand insertCommand,
   DbCommand updateCommand,
   DbCommand deleteCommand,
   string tableName,
   bool ignoreConcurrencyExceptions,
   bool supportInsert,
   bool supportUpdate,
   bool supportDelete
)

 function Leadtools.Medical.DataAccessLayer.SqlProviderUtilities.UpdateTable(DataSet,DbConnection,DbTransaction,DbDataAdapter,DbCommand,DbCommand,DbCommand,String,Boolean,Boolean,Boolean,Boolean)( 
   updatingDataset ,
   connection ,
   transaction ,
   dataAdapter ,
   insertCommand ,
   updateCommand ,
   deleteCommand ,
   tableName ,
   ignoreConcurrencyExceptions ,
   supportInsert ,
   supportUpdate ,
   supportDelete 
)

public:
static void UpdateTable( 
   DataSet^ updatingDataset,
   DbConnection^ connection,
   DbTransaction^ transaction,
   DbDataAdapter^ dataAdapter,
   DbCommand^ insertCommand,
   DbCommand^ updateCommand,
   DbCommand^ deleteCommand,
   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.

insertCommand

The System.Data.Common.DbCommand to be used for the insert operation.

updateCommand

The System.Data.Common.DbCommand to be used for the update operation.

deleteCommand

The System.Data.Common.DbCommand to be used for the delete operation.

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: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlProviderUtilities Class
SqlProviderUtilities Members
Overload List