I have a project that I'm really struggling for the first time in years with in .NET.
I have a datalist that returns filtered data. The data is student employees. Each employee has a SID. I am attempting to group by SID, and display a total for each SID on the last line item for that SID.
I'm open to ANY suggestions to get this running.
I've tried a for each loop in the item_databound of the datalist, but it returns the first SID and it's total each time. Inside the loop, I run a select to a gridview using the sum(total) as "SubTotal" method.
I have a datalist that returns filtered data. The data is student employees. Each employee has a SID. I am attempting to group by SID, and display a total for each SID on the last line item for that SID.
I'm open to ANY suggestions to get this running.
I've tried a for each loop in the item_databound of the datalist, but it returns the first SID and it's total each time. Inside the loop, I run a select to a gridview using the sum(total) as "SubTotal" method.