Threading on datarows in a datatable

Question

There is a dataset that has 1000 rows.

i can use only 5 threads that has to process all 1000 rows. Need a method for this passing datatable as parameter to the method and iterating through the rows.

For instance,

If the first 5rows are processed by the first 5 threads initially,

Then when any one of those 5 thread completes the process the thread is free, it has to process the next available data row in the data table. and this has to continue til 1000 rows are complete.. but ONLY using 5 threads

Sam Hobbs · Answer

It seems easy enough to write something. I assume you would use events to synchronize everything. I also assume you would get abundant results if you were to search for thread pools. If you have not tried searching then it would be more productive for you to try that instead of one of us doing it for you. Try this .

Prabhu Chandramouleesw · Answer

Suthish - i have a datatable that has 1000 rows. i can use only 5 threads that has to process all 1000 rows. Need a method for this passing (datatable dt)as parameter to the method and iterating through the rows therby processing every cells in the datarow being processed. For instance If the first 5rows are processed by the first 5 threads initially Then when any one of those 5 thread completes the process the thread is free it has to process the next available data row in the data table. and this has to continue til 1000 rows are complete.. but ONLY using 5 threads Would be of great help

Suthish Nair · Answer

Prabhu Can you explain what you want to do with this kind of logic?

Prabhu Chandramouleesw · Answer

Yes! i did that i had a Fibonacci example in MSDN but i was not quite sure how to limit the number of threads. Would be of great help if you can help me with a short method with datatable as a parameter passed with 5 threads iterating through the datarows

Sam Hobbs · Answer

Isn't that called thread pooling? Look for articles and such about thread pooling. Also .Net 4 has a Task class that I think would help but don't ask me for details; I have a book about it but I have not read enough of the book.