Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Get data from sql, Group, and Assign to array

reppelzreppelz PhilippinesMember Posts: 3
Original Query:
Jan-01 |  {"Barako", "Cappuccino", "Latte"}
Jan-02 |  {"Barako", "White Coffee", "3 in 1 Orignal"}


and then I have grouped them and insert into array

- Cappuccino
- Latte
- 3 in 1 Original
- White Coffee
- Barako

{"Cappuccino", "Latte", "3in1Orginial", "WhiteCoffee", "Barako"}


Now I want to re-assign them back to their designated arrays.

ex. 

Jan-01 |  {"Barako", "Cappuccino", "Latte"}
Jan-02 |  {"Barako", "White Coffee", "3 in 1 Orignal"}

**what should I use in my c# class

do i have to foreach them? or what?**

Sign In or Register to comment.