UpdateTable(DataSet,DbConnection,DbTransaction,DbDataAdapter,DbCommandBuilder,string,bool,bool,bool,bool) Method

Summary

Performs any Insert, Update or Delete operation in a specific System.Data.DataTable object to the database engine.

Syntax
C#
VB
C++
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 Overloads 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 _ 
)  
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.

Requirements

Target Platforms

Help Version 20.0.2020.5.27
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2020 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Medical.DataAccessLayer Assembly