CODEWITHSUNDEEP
c#.netdatatable
Zain Ali
Zain Ali

Reputation: 15993

Update a DataTable in C# without using a loop?

Let suppose there are three columns in my DataTable

  1. code

  2. name

  3. color

If I know the code and name, how can I update the color of that specific row whose code and name match my criteria? I want to do this without using Loops!

Upvotes: 9

Views: 87571

Answers (5)

Szöllősy Árpád
Szöllősy Árpád

Reputation: 11

With LINQ:

var dataRows = dt.AsEnumerable().Select(c => { c["color"] = c["Code"].ToString() == "1" ? "Red" : "White"; return c; });
dt = dataRows.CopyToDataTable();

Upvotes: 0

Yeng
Yeng

Reputation: 51

DataTable recTable = new DataTable();

// do stuff to populate table

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

Upvotes: 5

CharithJ
CharithJ

Reputation: 47570

// Use the Select method to find all rows matching the name and code.
DataRow[] rows = myDataTable.Select("name 'nameValue' AND code = 'codeValue');

for(int i = 0; i < rows.Length; i ++)
{
      rows[i]["color"] = colorValue;
}

Upvotes: 13

Farinha
Farinha

Reputation: 18091

You can use LINQ:

DataRow dr = datatable.AsEnumerable().Where(r => ((string)r["code"]).Equals(someCode) && ((string)r["name"]).Equals(someName)).First();
dr["color"] = someColor;

Of course I'm assuming all those criteria are strings. You should change the casts to the correct types.

Upvotes: 17

Darren Young
Darren Young

Reputation: 85

You could do:

 foreach (DataRow row in datatable.Rows)
        {
            if(row["code"].ToString() == someCode && row["name"].ToString() == someName)

              {
                  row["color"] = someColor;
              }


        }

Upvotes: -3

Related Questions