Extracting data from a datatable

Hi

I am creating a procedure where i have a excel file containing hundreds of rows of data, however i only need access to a few rows, i have created a datatable reading in the necessary rows.

The next stage is opening an application getting a project code and entering the information in the application then submitting it. I was wondering what is the best possible way to read the whole datatable in so once the first project is completed it can then go and next the next project code from my datatable?

Thanks