Change Datarow field value

Question

First I have last update file from DB

DataTable excelData = ReadSCOOmega(lastUploadFile);

, after this iterate over this data

foreach (DataRow currentRow in rows)
{
     currentRow.
}

Is that possible to change da data in the foreach loop.I can access only the value of this data

currentRow.Field<object>("Some column name")

but not to change it.My idea is selected.I have a multiple deals in excel file and when is upload to DB, I need to make changes in this file.Is that possible or I need to store the data in other collection?

score 19 · Answer 1 · answered May 10 '16 at 19:46

19

You can do that like :

foreach (DataRow currentRow in excelData.Rows)
{
    currentRow.BeginEdit();
    currentRow["ColumnName"] = value;
    //.....
    currentRow.EndEdit();
}

answered May 10 '16 at 19:46

Abdellah OUMGHAR

3,627
1
11
16

score 14 · Accepted Answer · answered May 10 '16 at 17:18

14

You can use indexer to set the data stored to the field: currentRow["columnName"] = value.

See MSDN DataRow.Item Property

answered May 10 '16 at 17:18

V.Leon

546
4
9

Change Datarow field value

2 Answers2