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

781

i have no idea

Answers (3)

Next Recommended Forum

how to give path in datagridview image column dynamically.

progress bar in winforexecutem C# on method

Forum Statistics

Please welcome our newest member abdelrhman elhusein ismail.
3,083,681 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 7 new threads, 22 new posts, and 73 new users.
In last week, the most popular thread is 'what's difference between .NET framework and C# language?'.

Upcoming Events

View all

Excel Automation with Power Automate : Automate Your Business Processes - Ep.3
Global Azure Bootcamp - Rasipuram
Software Architecture Conference - 2025