DataTable dt = new DataTable(); dt.Columns.Add("customerId", typeof(string)); dt.Columns.Add("invoiceAmt", typeof(double)); dt.Rows.Add("C001", 123.01); dt.Rows.Add("C002", 123.11); dt.Rows.Add("C001", 123.21); dt.Rows.Add("C003", 123.31); dt.Rows.Add("C001", 123.41); dt.Rows.Add("C004", 123.51); foreach (DataRow row in dt.Rows) { if ((string)row["customerId"]=="C001") { (row["invoiceAmt"]) = (Double)(row["invoiceAmt"]) + 100; } Console.WriteLine((string)row["customerId"] + " " + row["invoiceAmt"].ToString()); }But I'm not at all sure if that is exactly what you need. Are you trying to set a bunch of records or just one?