Inserting data into datatable based on row value

Question

Lets say you have a datatable with the following three columns:

ID,Size,Value

Is it possible to update the value column of a specific row based on the value of the ID of that row, pretty much to be able to run a SQL query of there is faster or better way?

Tim Schmelter · Accepted Answer · 2013-08-11 01:15:04Z

1

Is it possible to update the value column of a specific row based on the value of the ID of that row

Yes, you can use DataRow.SetField and a little bit of Linq:

var rowsToUdate = dt.AsEnumerable()
    .Where(r => r.Field<int>("ID") == id);
foreach(DataRow row in rowsToUpDate)
    row.SetField("Value", newValue);

...pretty much to be able to run a SQL query of there is faster or better way?

So do you want to update the database instead of the DataTable? This part is confusing.

answered Aug 11, 2013 at 1:15

Tim Schmelter

462k79 gold badges721 silver badges981 bronze badges

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

2 Comments

user2593590 Over a year ago

Is it possible to be able to do the code you provided above, but select * on column ID and not need a where clause?

Tim Schmelter Over a year ago

@user2593590: What do you mean with "select * on column ID and not need a where "?

Collectives™ on Stack Overflow

Inserting data into datatable based on row value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related