I am trying to create an application in C# and VS2005, but I've stumbled into a problem with DataTables and I was hoping someone could help.
I have a DataTable, populated using ADO and the SqlDataAdapter that looks similar to the picture below (Its a simplified datatable screenshot from SQL Server Management Studio for illistration purposes). As you can see, there is more that 1 record that shares the same test_case value but is made unique by the Test_type column.
My query returns the data similar to the picture below, it is ordered by test_case and then test_type.
The steps I'd like to take...
1) Create a subset from the datatable of all records sharing the same test_case value (e.g All records where Test_Case = 2) ,preserving the order in the image.
2) Do some processing with each row of the subset
3) Loop and repeat the process for the next subset of records (Where test_case = 3) and so on.
The image only shows two of each test_case value, but more advanced versions may have 10 + records with the same test_case.
Thanks in advance