AddToBatch Method

DbDataAdapter.AddToBatch Method

Note: This method is new in the .NET Framework version 2.0.

Adds a IDbCommand to the current batch.

Namespace: System.Data.Common
Assembly: System.Data (in

Protected Overridable Function AddToBatch ( _
	command As IDbCommand _
) As Integer
Dim command As IDbCommand
Dim returnValue As Integer

returnValue = Me.AddToBatch(command)
protected int AddToBatch (
	IDbCommand command
protected function AddToBatch (
	command : IDbCommand
) : int



The IDbCommand to add to the batch.

Return Value

The number of commands in the batch before adding the IDbCommand.

Exception typeCondition


The adapter does not support batches.

In DbDataAdapter, this method throws NotSupportedException. Classes that inherit from DbDataAdapter override this method to provide support for batches.

Notes to Implementers This method is protected and is designed for use by a .NET Framework data provider. If a class that inherits from DbDataAdapter supports batches, that class overrides this method to allow users to add a command to a batch.

Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0

.NET Compact Framework

Supported in: 2.0

Community Additions

© 2015 Microsoft