Hi, Having dt and need to check the comments column is empty, if it is empty then update value as “No record” in the same table using linq query. Ex: User Date Time Comments 123 10/15/2024 19:03:34 Changed 121 10/16/2024 19:03:34 Updates 129 10/18/2024 19:05:34 commit 127 10/19/2024 …

Try using the below Linq Query: dt.AsEnumerable().Where(Function(row) String.IsNullOrEmpty(row(“Comments”).ToString())).ToList().ForEach(Sub(row) row(“Comments”) = “No record”) Here dt represents datatable variable.

How to check the column value is null and update with string using linq query

Help Studio

system (system) Closed February 1, 2025, 5:39am 6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
How to update a row value in a datatable by checking another row value using LINQ Studio studio , question , activities_panel	4	1110	June 15, 2022
Update column "Comments" based on the search condition from column "Reason Code" using LINQ Studio studio	4	1652	August 21, 2021
Datatable query for update the column values Activities web	5	599	May 23, 2023
Linq query for updating a value in a datatable based on a condition Studio studio , question , activities_panel	10	1476	September 23, 2022
Check Null Value in Select Query Help datatable	3	4157	August 9, 2017

How to check the column value is null and update with string using linq query

Related topics