c# - Linq Query, looping thru datatable, joining and get the index -

c# - Linq Query, looping thru datatable, joining and get the index -

i have linq query have 2 datatables joining , looping thru using .foreach , manipulating info in the foreach. how row index of row while looping thru in foreach?

i know how out bring together in , easy way set int variable before linq statement , increment in foreach., wanted know if can add together .select(row,index) => new {row,index}) in query

datatable1.asenumerable() .join(datatable2.asenumerable(), dt1row => dt1row.field<string>("name"), dt2row => dt2row.field<string>("name")) , (dt1row, dt2row) => new { dt1row, dt2row }).tolist() .foreach(o => { //check if value fields same in });

you seek one:

datatable1.asenumerable() .join(datatable2.asenumerable(), dt1row => dt1row.field<string>("name"), dt2row => dt2row.field<string>("name")) , (dt1row, dt2row) => new { dt1row, dt2row }) .select((row, index)=> new { index=index, dt1row = row.dt1row, dt2row = row.dt2row }).tolist() .foreach(o => { //check if value fields same in });

c# linq