LINQ get particular rows from in array

Question

I joined two datatables & trying to get the results in the array.

dt
ID   A    B    C
1    ab   t    j
2    cd   h    k
3    ds   f    g

ndt
CID     E    F   G
1       g    y   gg
2       ff   hg  vcb
3       df   vb   b

Code

var query = from r0w1 in dt.AsEnumerable()
            join r0w2 in ndt.AsEnumerable()
                 on r0w1.Field<string>("ID") equals r0w2.Field<string>("CID")
                 select r0w2.ItemArray.Concat(r0w1.ItemArray).ToArray();

What I want here is no to select the column CID from above result since both the columns ID & CID are same. How can I avoid it ?

can u show sample data inputs and expected output?

DevT
– DevT

2015-12-14 05:51:13 +00:00
Commented Dec 14, 2015 at 5:51 — DevT
– DevT, Commented Dec 14, 2015 at 5:51

Yeldar Kurmangaliyev · Accepted Answer · 2015-12-14 05:57:22Z

1

Assuming that CID always goes first in your row, you can utilize LINQ Skip to skip the first item:

var query = from r0w1 in dt.AsEnumerable()
            join r0w2 in ndt.AsEnumerable()
            on r0w1.Field<string>("ID") equals r0w2.Field<string>("CID")
            select r0w2.ItemArray.Skip(1).Concat(r0w1.ItemArray).ToArray();

edited Dec 14, 2015 at 5:57

answered Dec 14, 2015 at 5:51

Yeldar Kurmangaliyev

34.3k13 gold badges64 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Harshit Over a year ago

Sorry, that was writing mistake, but that was not the actual problem.

sachin Over a year ago

This answer should work provided that "CID" is first column as shown in output.

Collectives™ on Stack Overflow

LINQ get particular rows from in array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related