Problem
How to get same Items Exist in two Data tables in third data table by linq to sql and display in datagridview
in windows form application visual studio 2015.
Meaning I Have two datatables
First Data table is dt Get data from Excel .
Second is dtItems get data from sql server 2014 database .
I need when I have itemcode 12 and this item exist on two datatables
dt(display data from excel) AND dtItems (Display data from sql server)
show them in datagridview
if itemcode 12 exist on dt and dtItems display on datagridview .