How to relationship two DataTable and get Results in the third DataTable using Linq commands? Without the use of for loop

Question

hi

I want without using the for loop .thank

I asked this question before, but this time I need the linq method. in:

https://learn.microsoft.com/en-us/answers/questions/1288478/how-to-relationship-two-datatable-and-get-results

        Dim dtParent As New DataTable
        Dim dtChild As New DataTable
        Dim dtResult As New DataTable
        dtParent.Columns.Add("filter")
        dtParent.Columns.Add("words")
        dtParent.Rows.Add({"a", "w1"})
        dtParent.Rows.Add({"b", "w2"})
        dtParent.Rows.Add({"c", "w3"})
        dtParent.Rows.Add({"k", "w4"})
        dtParent.Rows.Add({"m", "w5"})
        dtChild.Columns.Add("Filter")
        dtChild.Rows.Add("k")
        dtChild.Rows.Add("b")
        dtChild.Rows.Add("c")

Answer 1

Hi @Mansour_Dalir ,

You can refer to the following code.

Dim resultTable As New DataTable("Result")
resultTable.Columns.Add("filter")
resultTable.Columns.Add("words")

Dim query = dtParent.AsEnumerable() _
            .Join(dtChild.AsEnumerable(),
                  Function(parentRow) parentRow("filter").ToString(),
                  Function(childRow) childRow("Filter").ToString(),
                  Function(parentRow, childRow) New With {
                      .Filter = parentRow("filter"),
                      .Words = parentRow("words")
                  }) _
            .OrderBy(Function(row) row.Filter)

query.Select(Function(row) resultTable.Rows.Add(row.Filter, row.Words)).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.