Threading on datarows in a datatable

Prabhu Chandramouleesw

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
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 Chandramouleesw15y ago
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 Nair15y ago
Prabhu,

Can you explain what you want to do with this kind of logic?
Prabhu Chandramouleesw15y ago
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 Hobbs15y ago
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.