Linq query for updating a value in a datatable based on a condition

Help Studio
, ,
1

I have a datatable dt
There is a column named status
if value of status= “-” need to update the status column as completed

Could anyone please help me with a LINQ query. I can do the same with for loop but i need query in LINQ

2

Hi @muhamed.fasil

How about this expression

(From row In dt.AsEnumerable()
Let modCol = row.Field(Of String)("Status").ToString.Replace("-","completed")
Let ra = row.ItemArray.Skip(1).Prepend(modCol).ToArray()
Select Dt1.Rows.Add(ra)).CopyToDataTable()

Regards
Gokul

3

Hi gokul,
do i need to clone Dt to create DT1? u have mentioned a datatable variable in the last SELECT query

I am not able to use the query directly in code , getting error as the Dt1 was not declared

4

Hi @muhamed.fasil

Check Out the XAML file

UpdateStatus.xaml (8.8 KB)

Output

image

Regards
Gokul

5

@Gokul001

I have more than 1 column in my datatable, no of columns may vary w.r.t input excel

For example see the input sheet below

image

6

HI @muhamed.fasil

Check Out the update XAML file

image
image522×557 24.5 KB

UpdateStatus.xaml (11.0 KB)

Regards
Gokul

7

@Gokul001

Bro u trying to update the first column ?, but i need to update the column named “status”

To check that can you switch the columns in build datatable and check the output

8

Share the Input @muhamed.fasil

9

For me this the Output @muhamed.fasil

image

10

if i switch the positions of input datatable columns , still the updation is happening on Column1 itself
source.xlsx (9.0 KB)

image
image1080×788 50.3 KB

11

Hi @muhamed.fasil

Check Out the Updated XAML file

UpdateStatus.xaml (13.2 KB)

Output

source.xlsx (9.7 KB)

Regards
Gokul