VistaDB 6
VistaDB.Provider Namespace / VistaDBDataAdapter Class / Fill Method / Fill(DataSet,Int32,Int32,String,IDbCommand,CommandBehavior) Method
A System.Data.DataSet to fill with records and, if necessary, schema.
The zero-based record number to start with.
The maximum number of records to retrieve.
The name of the source table to use for table mapping.
The SQL SELECT statement used to retrieve rows from the data source.
One of the System.Data.CommandBehavior values.


In This Topic
    Fill(DataSet,Int32,Int32,String,IDbCommand,CommandBehavior) Method
    In This Topic
    Adds or refreshes rows in a specified range in the System.Data.DataSet to match those in the data source using the System.Data.DataSet and source table names, command string, and command behavior.
    Syntax
    'Declaration
     
    
    Protected Overloads Function Fill( _
       ByVal dataSet As System.Data.DataSet, _
       ByVal startRecord As System.Integer, _
       ByVal maxRecords As System.Integer, _
       ByVal srcTable As System.String, _
       ByVal command As System.Data.IDbCommand, _
       ByVal behavior As System.Data.CommandBehavior _
    ) As System.Integer
    'Usage
     
    
    Dim instance As VistaDBDataAdapter
    Dim dataSet As System.Data.DataSet
    Dim startRecord As System.Integer
    Dim maxRecords As System.Integer
    Dim srcTable As System.String
    Dim command As System.Data.IDbCommand
    Dim behavior As System.Data.CommandBehavior
    Dim value As System.Integer
     
    value = instance.Fill(dataSet, startRecord, maxRecords, srcTable, command, behavior)
    protected System.int Fill( 
       System.Data.DataSet dataSet,
       System.int startRecord,
       System.int maxRecords,
       System.string srcTable,
       System.Data.IDbCommand command,
       System.Data.CommandBehavior behavior
    )

    Parameters

    dataSet
    A System.Data.DataSet to fill with records and, if necessary, schema.
    startRecord
    The zero-based record number to start with.
    maxRecords
    The maximum number of records to retrieve.
    srcTable
    The name of the source table to use for table mapping.
    command
    The SQL SELECT statement used to retrieve rows from the data source.
    behavior
    One of the System.Data.CommandBehavior values.

    Return Value

    The number of rows successfully added to or refreshed in the System.Data.DataSet. This does not include rows affected by statements that do not return rows.
    Exceptions
    ExceptionDescription
    The source table is invalid.
    The startRecord parameter is less than 0. -or- The maxRecords parameter is less than 0.
    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