To include paging for a small query result the following statement can be used
adapter.Fill(dataSet, currentIndex, pageSize, "Orders")
adapter.Fill(dataSet, "Orders")
adapter.Fill(pageSize,dataSet,"Orders",1)
dataSet.Tables("Orders").Rows