How to Edit a row in the datatable

Question

I have created a data table  It has 3 column Product id  Product name and Product price      Datatable table  new DataTable  Product         table Columns Add  Product id   typeof int        table Columns Add  Product name   typeof string        table Columns Add  Product price   typeof string         table Rows Add 1   abc    100        table Rows Add 2   xyz    200      Now I want to find by index  and update that row   say for e g    I want to change value of Product name column to  cde  that has the Product id column value   2

User · Answer

If your data set is too large first select required rows by Select(). it will stop further looping.

DataRow[] selected = table.Select("Product_id = 2")

Then loop through subset and update

    foreach (DataRow row in selected)
    {
        row["Product_price"] = "<new price>";
    }

User · Answer

Try the SetField method   By passing column object    table Rows rowIndex  SetField column  value     By Passing column index    table Rows rowIndex  SetField 0   column index    value     By Passing column name as string    table Rows rowIndex  SetField  product name    columnName    value

User · Answer

Try this I am also not 100   sure          for  int i   0  i lt  dt Rows Count  i                         If dt Rows i  Product id    2                             dt Rows i  Columns  Product name   ColumnName    cde

User · Answer

First you need to find a row with id    2 then change the name so   foreach DataRow dr in table Rows     search whole table       if dr  Product id      2     if id  2               dr  Product name      cde     change the name           break  break or not depending on you           You could also try these solutions   table Rows 1   Product name      cde     not recommended as it selects 2nd row as I know that it has id 2   Or   DataRow dr   table Select  Product id 2   FirstOrDefault       finds all rows with id  2 and selects first or null if haven t found any if dr    null        dr  Product name      cde     changes the Product name

User · Answer

You can find that row with  DataRow row   table Select  Product id 2   FirstOrDefault      and update it  row  Product name      cde

User · Answer

You can traverse through the DataTable like below and set the value  foreach DataTable thisTable in dataSet Tables        foreach DataRow row in thisTable Rows                row  Product name      cde             OR  thisTable Rows 1   Product name      cde     Hope this helps

[c#] How to Edit a row in the datatable

Examples related to c#

Examples related to datatable