I have the following code where I am attempting to count the rows under each grouping/band in a DataTable. This is currently counting ALL rows in the specified band index and returning that value to all band1 rows. I need a way of counting rows under each band in band1 and not all rows under band1, then return that value to each summary band. This is not the end result desired but I think I can finish if I can just get each band to have a unique value for rows under it rather than all rows applying the same specified condition.
foreach (DataRow rows in dataSetDS.Tables["dataTable1_band1"].Select())
{
rows["column"] = dataSetDS.Tables["dataTable1_band2"].Rows.Count.ToString();
}
Current output to Excel using syntax above.
Desired output:
