varD = fromD1inchpdt1.asenumerable () fromD2inchpdt2.asenumerable ()whereD1. field<string> ("ID") = = D2. field<string> ("ID") Select New{a = D1. field<string> ("ID"), V = d1. field<Double> ("VALUE") * D2. field<Double> ("VALUE") }; varD = pdt1.asenumerable (). Join (Pdt2.asenumerable (), s = = s.field<string> ("ID"), SC = sc. field<string> ("ID"), (s, sc) = =New{a= s.field<string> ("ID"), v= s.field<Double> ("VALUE") * SC. field<Double> ("VALUE") });
example, an operation between three DataTable
varD = pdt1.asenumerable (). Join (Pdt2.asenumerable (), s = = s.field<string> ("ID"), SC = sc. field<string> ("ID"), (s, sc) = =New{a= s.field<string> ("ID"), v= s.field<Double> ("VALUE") * SC. field<Double> ("VALUE") }); DataTable pDT3=Pgetdt (); foreach(varLinchd) {DataRow PDR=Pdt3.newrow (); pdr[0] =L.A; pdr[1] =l.v; PDT3.ROWS.ADD (PDR); Console.WriteLine ("{0} {1}", L.A, L.V); } varE = fromD1inchD fromD2inchpdt1.asenumerable ()whered1.a = = D2. field<string> ("ID") Select New{a = d1.a, V = convert.todouble (d1.v)-D2. field<Double> ("VALUE") }; foreach(varLinchE) {Console.WriteLine ("{0} {1}", L.A, L.V); } console.readline ();
Conversion of LINQ, LAMBDA