LINQ join Table

Asked Jun 21 '17 at 02:11

Active Jul 16 '19 at 11:28

Viewed 31 times

 Dim req_view_item = From ppmp_item In dbcon.tblPPMPs Join ppmp_req In dbcon.tblREQUESTs _
                            On ppmp_item.IDN Equals ppmp_req.IDN
        req_dgv.DataSource = req_view_item

What's wrong with my code it didn't join the two table.. this is the result..

edited Jul 16 '19 at 11:28

Catarina Ferreira

1,824
5
17
26

asked Jun 21 '17 at 02:11

blue_pearl

Possible duplicate of [What is the syntax for an inner join in LINQ to SQL?](https://stackoverflow.com/questions/37324/what-is-the-syntax-for-an-inner-join-in-linq-to-sql) – Tien Nguyen Ngoc Jun 21 '17 at 02:16
i didnt get you sir – blue_pearl Jun 21 '17 at 02:35
i try find some syntax sir – blue_pearl Jun 21 '17 at 02:35
sir are familiar with stored procedure? past days you gave me your code but i cant make it to stored procedure.. and call the stored procedure using LINQ – blue_pearl Jun 21 '17 at 02:36
i search it sir ..thanks – blue_pearl Jun 21 '17 at 02:39
You need to perform SELECT with results of join query and probably using `ToList()` afterwards. – Tetsuya Yamamoto Jun 21 '17 at 03:59

LINQ join Table

0 Answers0