LEADTOOLS Medical (Leadtools.Medical.DataAccessLayer assembly)

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

Show in webframe





The System.Data.DataSet which contains the System.Data.DataTable to update.
The System.Data.Common.DbConnection to use to connect to the database.
The System.Data.Common.DbTransaction to use when updating the changes into the database.
The System.Data.Common.DbDataAdapter which corresponds to the same type of the database provider.
The System.Data.Common.DbCommand to be used for the insert operation.
The System.Data.Common.DbCommand to be used for the update operation.
The System.Data.Common.DbCommand to be used for the delete operation.
The name of the System.Data.DataTable which will be updated into the database.
true to ignore System.Data.DBConcurrencyException exceptions while updating the database and continue the update.
true to create an Insert command which will insert all the new rows in the referenced System.Data.DataTable.
true to create an Update command which will update all the modified rows in the referenced System.Data.DataTable.
true to create a Delete command which will delete all the removed rows in the referenced System.Data.DataTable.
Performs any Insert, Update or Delete operation in a specific System.Data.DataTable object to the database engine.
Syntax
'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)

            

            

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.
Requirements

Target Platforms

See Also

Reference

SqlProviderUtilities Class
SqlProviderUtilities Members
Overload List

 

 


Products | Support | Contact Us | Copyright Notices
© 2006-2014 All Rights Reserved. LEAD Technologies, Inc.

Leadtools.Medical.DataAccessLayer requires a Medical toolkit server license and unlock key. For more information, refer to: Imaging Pro/Document/Medical Features