Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - .NET Programming » UltraLite .NET 1.0 API Reference » ULDataAdapter class

Fill method Next Page

Fill method

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


public int Fill(
DataSet dataSet,
string srcTable

Return value

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] IDataAdapter.Fill.

See also