Description
Advanced Visual Basic 2010 Chapter 7 Programming Challenge 4 Grouping Payments by Member Name
Use the Group By operator to group the Payments table by the members combined first and last names. Display the member name in the outside group, and display the individual payment dates and amounts within each group. Write the output to a ListBox control, as demonstrated in Figure 7-20.
Hint: The Group By operator permits only a single key field, so you will have to create an anonymous type and assign it an alias name, called MemberName here:
Group aPayment By MemberName = New With {aPayment.Member.First_Name, aPayment.Member.Last_Name}
Reviews
There are no reviews yet.