In This Topic
Gets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.
Syntax
'Declaration
<System.ComponentModel.DefaultValueAttribute(1)>
<ResDescriptionAttribute("DbDataAdapter_UpdateBatchSize")>
<ResCategoryAttribute("DataCategory_Update")>
Public Property UpdateBatchSize As System.Integer
'Usage
Dim instance As VistaDBDataAdapter
Dim value As System.Integer
instance.UpdateBatchSize = value
value = instance.UpdateBatchSize
[System.ComponentModel.DefaultValue(1)]
[ResDescription("DbDataAdapter_UpdateBatchSize")]
[ResCategory("DataCategory_Update")]
public System.int UpdateBatchSize {get; set;}
Property Value
The number of rows to process per batch. Value is Effect 0 There is no limit on the batch size. 1 Disables batch updating. > 1 Changes are sent using batches of
System.Data.Common.DbDataAdapter.UpdateBatchSize operations at a time. When setting this to a value other than 1, all the commands associated with the
System.Data.Common.DbDataAdapter must have their
System.Data.IDbCommand.UpdatedRowSource property set to None or OutputParameters. An exception will be thrown otherwise.
Requirements
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
See Also