Here are two ways to read data from a database and iterate through the results. The second way will again use the SQLClient class, but this time we will load the data into a DataTable and then loop through each row of the table. How to loop through all rows in DataTables jQuery? Excel. Details: If you are using the legacy DataTables then you can get all the rows even the paginated ones, as shown below › Get more: Iterate datatable rowsShow All. How to loop through each row in an Excel file in Microsoft Power. An alternative to for and for/in loops is Array.prototype.forEach (). The forEach runs a function on each indexed element in an array. Starting at index [0] a function will get called on index [0], index [1], index [2], etc forEach will let you loop through an array nearly the same way as a for loop:. "/>.