UPDATE Tablename SET Somefield = Somefield + 'Some value' WHERE SomeField = 'Some other value' ;

Clarify your question again with more detail.

public void Processs(string deptcode, int payrollno) { try { List Employees = _ctx.TBL_PAY.Where(x => x.PAYROLL_NO == payrollno && x.DEPT_CODE == deptcode).ToList(); foreach (TBL_PAY Employee in Employees) { Employee.LOAN_AMOUNT__1 = 100; Employee.LOAN_HEADER__1 = "TEST"; } _ctx.SaveChanges(); } catch (Exception) { return; } } this is my code. how can i update the value in tbl_pay from the value of another table

Answers

how can update table value using other table value in c#

Lester Bautista

825

i have no idea

how can update table value using other table value in c#

Answers (3)