Update multiple rows in datatable without loop

Question

I have two datatable with conditions in application and want some processing for multiple rows to update column value.

For example:

I have datatable1 with 10000 rows. I want to filter rows by datatable.select("condition") and as per condition, I want to update row values.

If for any condition, I found 20 rows from datatable. I want to update those 20 records in one shot. Not in any loop. I have datarow array for those values to update in datable.

How exactly do you want to update the rows? This seems like something you could probably do with a dynamic query using the in keyword. — Kippie
– Kippie, Commented Sep 16, 2013 at 14:11
How do you think you can do it without a loop? If framework provides some method also it will be internally doing a loop! — Sriram Sakthivel
– Sriram Sakthivel, Commented Sep 16, 2013 at 14:11
maybe he means with lambda expressions.. but there will be anyway a loop — darkdog
– darkdog, Commented Sep 16, 2013 at 14:16
@Sriram - Yes, I know but better way or anything or any method which I am not aware if! Thats the reason I posted question. — Briskstar Technologies
– Briskstar Technologies, Commented Sep 16, 2013 at 14:19
@darkdog - Thanks for your understanding. Something similar I am looking for. — Briskstar Technologies
– Briskstar Technologies, Commented Sep 16, 2013 at 14:19

Rajesh Subramanian · Accepted Answer · 2013-09-16 14:16:51Z

11

You can try out the following linq,

DataTable recTable = new DataTable();

// do stuff to populate table

recTable.Select(string.Format("[code] = '{0}'", someName)).ToList<DataRow>().ForEach(r => r["Color"] = colorValue);

You can substitute your columns and values here...

answered Sep 16, 2013 at 14:16

Rajesh Subramanian

6,4855 gold badges33 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sriram Sakthivel Over a year ago

Loop is far far efficient than this

Rajesh Subramanian Over a year ago

this is just a way to update without using loops externally. if performance is a constraint, then go for Parallel For.

Briskstar Technologies Over a year ago

Thanks for inputs and suggestions.

Anjali Over a year ago

string.Format("[Code]='{0}'",somename) what is code here and what is somename. are you updating the value of code

sivabalan · Accepted Answer · 2014-08-20 08:04:30Z

2

To Update Row With Multiple Condition use This

    datatable.Select(string.Format("[lineNo]='{0}' and [Position]>='{1}' ", lineNo, Position)).ToList<DataRow>().ForEach(r => r["Linetext"] ="Sample Text" );

edited Aug 20, 2014 at 8:04

answered Aug 20, 2014 at 7:48

sivabalan

1692 silver badges6 bronze badges

1 Comment

Ryan Tirrell Over a year ago

This is just a fancier way of still doing a loop - Note the 'ForEach(...)'

Sarath Subramanian · Accepted Answer · 2017-03-28 17:27:17Z

0

If you want to default a column value with abc use Expression, then you could use the below code.

dt.Columns.Add("ColumnName").Expression = "'abc'";

In case if you need to pass the value dynamically using a variable, you could use the below code.

string str = "abc";
dt.Columns.Add("ColumnName").Expression = "'" + str + "'";

answered Mar 28, 2017 at 17:27

Sarath Subramanian

21.6k12 gold badges89 silver badges95 bronze badges

Comments

Alejandro López Haro · Accepted Answer · 2024-07-04 00:29:31Z

0

An example in VB.NET

dt.Select("id = 1").ToList().ForEach(Sub(drow) drow("val") = "number 1")

answered Jul 4, 2024 at 0:29

Alejandro López Haro

1

Collectives™ on Stack Overflow

Update multiple rows in datatable without loop

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Linked

Related