How to group the DataTable together with an array. 'Linq'

Question

hi

And how to get to the index number ("b") On ( OutPut Array)

        Dim MyDataTable As New DataTable
        MyDataTable.Columns.Add("A")
        MyDataTable.Columns.Add("B")
        MyDataTable.Rows.Add({"1", "a"})
        MyDataTable.Rows.Add({"2", "b"})
        MyDataTable.Rows.Add({"3", "a"})
        MyDataTable.Rows.Add({"4", "a"})
        MyDataTable.Rows.Add({"5", "c"})
        MyDataTable.Rows.Add({"6", "c"})

        'need this Result
        Dim OutPut = {({"a", ({1, 3, 4})}), ({"b", ({2})}), ({"c", ({5, 6})})}

Answer 1

Hi @Mansour_Dalir , You can refer to the following code, using GroupBy in linq.

        Dim outputArray = MyDataTable.AsEnumerable().
    GroupBy(Function(row) row.Field(Of String)("B")).
    Select(Function(group) New Tuple(Of String, List(Of Integer))(group.Key, group.Select(Function(row) Integer.Parse(row.Field(Of String)("A"))).ToList())).
    ToArray()

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

        Dim ArrOut = From iRow In MyDataTable.AsEnumerable()
        Group iRow.Item("A") By Head = iRow.Item("B") Into Group
        Select New Object() {Group, Head}
        ArrOut = ArrOut.ToArray