Multiple choice technology programming languages

To include paging for a small query result the following statement can be used

  1. adapter.Fill(dataSet, currentIndex, pageSize, "Orders")

  2. adapter.Fill(dataSet, "Orders")

  3. adapter.Fill(pageSize,dataSet,"Orders",1)

  4. dataSet.Tables("Orders").Rows

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The DataAdapter.Fill method has an overload that accepts starting record and maximum records parameters, enabling paging. currentIndex specifies where to start, pageSize limits records returned. The simpler overloads load all data at once.