使用linq/lambda在两个数据之间更新

Question

CtExcelData datatable1

DESIGNATION                        STATUS
------------------------------------------
ASSISTANT MANAGER - TRAINING       ACTIVE
ASSISTANT MANAGER - TRAINING       ACTIVE
ADMIN ASSISTANT                    ACTIVE

指定datatable2

DESIG_ID    DESIG_NAME
------------------------------------------
10          ASSISTANT MANAGER - TRAINING
20          ADMIN ASSISTANT

如果指定名称与使用lambda表达式的2个数据之间完全匹配，则我希望将datatable1 DESIGNATION文本替换为datatable2中的指定id。

两个表中将有多行。

Answer 1

//CtExcelData datatable imported from excel compared with Designation datatable fetched from db. Updated excel datatable with id from db table matching the designationname

foreach (DataRow row in CtExcelData.Rows){
DataRow desigRowsToUpdate = DS.Tables["Designation"].AsEnumerable().FirstOrDefault(r => r.Field<string>("Desig_Name").ToUpper().Trim() == row.Field<string>("DESIGNATION").ToUpper().Trim());
if (desigRowsToUpdate != null)
{
    row.SetField("DESIGNATION", desigRowsToUpdate.Field<decimal>("Desig_Id"));}
}