Hi
Daniele,
Thank
you for contacting Syncfusion support.
We
analyzed your query. You can achieve your requirement by using below code
snippet
Please
refer the following code snippet and sample in the following location:
Code Snippet:
DataTable dataTableSqlJoined = new DataTable();
var
result=from datarow1 in dataTable.AsEnumerable()
join
datarow2 in dataTable1.AsEnumerable()
on
datarow1.Field<int>("ID") equals datarow2.Field<int>("ID")
select
datarow1;
DataTable dataTableLinqJoined = result.CopyToDataTable();
DataSource =
dataTableLinqJoined.DefaultView;
|
Regards,
Farjana
Parveen A
Attachment:
DataTable_Linq_Query_7caf265c.zip