Hi All,
I am trying to compare columns of two datatables and if the value matches of any column i need to update it in status column specific to that particular row only where the value has matched.
Step1- What I have done is one for each row for 1st dtb and inside that for each control loop for 1st dtb cols…than inside that for each row of 2nd dtb and inside this for each control loop for 2nd dtb cols…and than finally inside the second for each control loop…I am using if else to compare both the dtb cols , but unfortunately it iterates and increase the col value for second dtb only and first dtb cols remains constant.
Step2- And have done the same thing with lookup, just used lookup inside the second for each control loop of 2nd datatable and provided its properties values as Datatable=“Datatable1”, Lookup Val= “row(dtcol1).ToString”, Lookup col=dtcol1
For both the above steps it is giving me error "Column ‘Name’ does not belong to table Datatable "
have attached the screensht and the zip file with xaml file and dummy data.
Thanks.