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 specified System.Data.DataTable.


Visual Basic

Overloads Public Function Fill( _
ByVal dataTable As DataTable _
) As Integer


public int Fill(
DataTable dataTable

Return value

The number of rows successfully added or refreshed in the System.Data.DataTable.


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 and no exception is raised.

For more information, see [external link] IDataAdapter.Fill.

See also