i have two data tables dt1 and dt2,and the result should be present in dt3 and attach to ultragrid using c#
dt1id name1 data12 data2 3 data34 data4
dt2id name1 data52 data6
result should be dt3id name3 data34 data4
Hello,
Thank you for contacting Infragistics Support.
This questions is related to the data source and it is not specific for Infragistics. However In order to subtract the rows of one data table from the rows of another data table you may iterate trough the tables, compare their rows and get the ones you need. You can also use LINQ expression to perform such action. More information about the approach you could find on the following links:
https://social.msdn.microsoft.com/Forums/en-US/1581f5aa-6500-4f40-8591-4b2446fc1c53/how-do-you-get-the-intersection-between-two-data-tables?forum=csharplanguage
http://stackoverflow.com/questions/485306/finding-the-intersection-of-two-net-datatables
Please find attached a sample solution implanting datatable subtract with LINQ expression.
Please let me know if you have any further questions related to Infragistics components
Thanks a lot,it is working as i expected