I want to update Status as “Not required” for all the rows in DT where the company code is not S1,S4, SR1 or SRS DT.Select(“[Company Code] <> ‘A’ AND [Company Code] <> ‘B’ AND [Company Code] <> ‘C’ AND [Company Code] <> ‘D’”).ToList().ForEach(r=> { r[ “Status” ] = “Not Required”}).CopyToDataTable I…

Hi, Do you try with C#? If so, the following helps you. [img20211013-2] arrayValidCode = new string[] {"S1","S4","SR1","SRS"}; dt.AsEnumerable().Where( r => !arrayValidCode.Contains( r.Field<string>("Company Code"))).Select(r => r["Status"]="Not Required").ToList(); Sample20211013-2CS.zip (2.9…

I want to update multiple rows of a Datatable based on a condition on column. I do not want to use for each as number of records are very high. I tried using LINQ but getting error. Please help

Help Studio

Yoichi (Yoichi) October 13, 2021, 8:53am 11

Hi,

Hope the following helps you

DataTable.Select method

The following is linked from the above page.

https://www.csharp-examples.net/dataview-rowfilter/

LINQ

For now, the following helps you.

Regards,

1 Like

Topic		Replies	Views
I want to update multiple rows in a data table based on the condition applied on columns Studio studio , question , activities_panel	10	7699	October 21, 2021
Error while using the data table argument in invoke code activity Activities datatable , excel , activities , question , invoke-code	5	2440	November 30, 2021
How to Update multiple rows in datatable Help datatable , studio	4	10170	November 13, 2021
How to update column's value in datatable with LINQ? Studio studio , question , activities_panel	21	7345	January 28, 2022
Datatable : update without for each activity Help	3	3592	March 13, 2019

I want to update multiple rows of a Datatable based on a condition on column. I do not want to use for each as number of records are very high. I tried using LINQ but getting error. Please help

Related topics