StringBuilder sql = new StringBuilder(); sql.Append("Select * From myTable"); string tableName = "myTable"; DataRow row; OleDbDataAdapter adapter = new OleDbDataAdapter(sql.ToString(), adoConGrainPlan); OleDbCommandBuilder cmdBldr = new OleDbCommandBuilder(adapter); DataSet ds = new DataSet(); adapter.Fill(ds, tableName); bool update = true; if (update) { row = ds.Tables[tableName].Rows[1]; row.BeginEdit(); } else { // new row row = ds.Tables[tableName].NewRow(); } row["myString"] = "new string" + Math.PI; row["myFloat"] = Convert.ToSingle(row["myFloat"]) + 1; row["myDouble"] = myDouble; row["myBoolean"] = myBool; if (update) { row.EndEdit(); } else { ds.Tables[tableName].Rows.Add(row); } adapter.Update(ds, tableName);