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
hi,I have created a datatable dt,with columns id ,name based on grouping hierarchyHere i need to drag and drop the items within grouphierarchy and save itbut problem here is,i have created the datatable dt,from searlization,so there is no database to save the changes so,now how should i save the changes made (drag and drop)in the ultragrid having grouping hierarchy.
Thanks a lot,it is working as i expected
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