Loading

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

Lester Bautista

i have no idea

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lester Bautista8y ago
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
Bharathi Raja8y ago
1. UPDATE Tablename
2. SET Somefield = Somefield + 'Some value'
3. WHERE SomeField = 'Some other value';

Rahul8y ago

Clarify your question again with more detail.