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

762

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

Leaderboard

View all

Rodrigo Diaz

Magnus Mårtensson

Tuhin Paul

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

186

13k

10.5k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

288.8k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.3k

58.5k

Upcoming events

View all

Suggested for you

View all

Vijay Kumari

Nitin Pandit

Babita

Jaish Mathews

Chetan Sanghani

Forum Statistics

Please welcome our newest member Amapola karlen.
3,077,165 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 5 new threads, 19 new posts, and 169 new users.
In last week, the most popular thread is 'Object reference not set to an instance of the Object.'.