How to Edit a row in the datatable

by

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
}

More Related Contents:

  1. Affect the datatable column value in C#
  2. LINQ query on a DataTable
  3. Convert datatable to JSON in C#
  4. How to export DataTable to Excel
  5. Sorting rows in a data table
  6. How to select distinct rows in a datatable and store into an array
  7. Export DataTable to Excel with EPPlus
  8. Read SQL Table into C# DataTable
  9. Combining n DataTables into a Single DataTable
  10. How to convert datatable to json string using json.net?
  11. Efficient DataTable Group By
  12. C# – Fill a combo box with a DataTable
  13. Check if value exists in dataTable?
  14. How to insert a data table into SQL Server database table?
  15. How to calculate the sum of the datatable column in asp.net?
  16. .NET – Convert Generic Collection to DataTable
  17. Simple way to copy or clone a DataRow?
  18. Exception using CopyToDataTable with “new {..}” LINQ query
  19. How to fill a datatable with List [duplicate]
  20. Thread safety for DataTable
  21. DataTable to JSON [duplicate]
  22. Datatable vs Dataset
  23. Convert DataTable to JSON with key per row
  24. Copy rows from one Datatable to another DataTable?
  25. SqlBulkCopy – The given value of type String from the data source cannot be converted to type money of the specified target column
  26. How do I use SELECT GROUP BY in DataTable.Select(Expression)?
  27. Replacing a DataReader with a DataTable
  28. How can I convert a DataTable to an XML file in C#?
  29. How do you Sort a DataTable given column and direction?
  30. Convert DataTable to Generic List in C#

Leave a Comment