|
Adds or refreshes rows into the named System.Data.DataTable of the specified System.Data.DataSet. The System.Data.DataTable named is created and added to the System.Data.DataSet if neccessary.
Visual Basic
Overloads Public Function Fill( _
ByVal dataSet As DataSet, _
ByVal srcTable As String _
) As Integer
C#
public int Fill(
DataSet dataSet,
string srcTable
);
dataSet A System.Data.DataSet to fill with records and optionally schema.
srcTable The name of the source table to use for table mapping.
The number of rows successfully added or refreshed in the System.Data.DataSet.
For large result sets, this can have a significant performance impact. An alternative is to use an ULDataReader when a read-only result set is sufficient, perhaps with SQL statements (ExecuteNonQuery) to carry out modifications. Another alternative is to use a ULTable that allows read-write access to the database.
If ULDataAdapter.SelectCommand does not return any rows, no tables are added to the System.Data.DataSet and no exception is raised.
For more information, see ![[external link]](gif/external.gif)
IDataAdapter.Fill.
System.ArgumentNullException - The dataSet or srcTable parameter is invalid.
InvalidOperationException - The ULDataAdapter.SelectCommand is invalid or, the table mapping is missing and ULDataAdapter.MissingMappingAction is set to System.Data.MissingMappingAction.Error or, the System.Data.DataTable is missing from the System.Data.DataSet and ULDataAdapter.MissingSchemaAction is set to System.Data.MissingSchemaAction.Error.