StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Performing a GROUP BY on a DataTable/BO...InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 09:52:11 GMT20Performing a GROUP BY on a DataTable/BO...http://forum.strataframe.net/FindPost2471.aspxI have a BO that is filled with data that could contain more than one division. How can I perform an aggregate function on this BO/DataTable to determine if I have more than one type of division? For example<br> <br> ID Division<br> 1 A<br> 2 A<br> 3 B<br> <br> I was wondering if there was a way to do this without making a trip to the database... whether it be a .NET way or a StrataFrame way.<br> <br> Thanks.<br>Fri, 25 Aug 2006 14:09:31 GMTStarkMikeRE: Performing a GROUP BY on a DataTable/BO...http://forum.strataframe.net/FindPost2482.aspxThanks.Fri, 25 Aug 2006 14:09:31 GMTStarkMikeRE: Performing a GROUP BY on a DataTable/BO...http://forum.strataframe.net/FindPost2481.aspxYou can do a DataTable.Select on the CurrentDataTable of the business object and select the rows that contain each of the 3 divisions.&nbsp; The method will return a DataRow array that contains the count of the records that match the given select, but that requires that you test each division type and then check the length of the returned array.&nbsp; DataTables cannot do any sort of complex or aggregate functions, so if it's too complex, you'll have to do it through the database.Fri, 25 Aug 2006 14:03:19 GMTStrataFrame TeamRE: Performing a GROUP BY on a DataTable/BO...http://forum.strataframe.net/FindPost2479.aspxGuys? Anybody? :cool:;)<br> <br> Would it just be easier to execute a stored procedure and create a data reader to get my result?Fri, 25 Aug 2006 13:38:26 GMTStarkMike