update-sql-dataset.cs

void Update(DataRow newRow, string connStr, string tableName)
{
    using MySqlDataAdapter da = new MySqlDataAdapter(
        $"select * from {tableName}",
        connStr
    );

    da.UpdateCommand = new MySqlCommandBuilder(da).GetUpdateCommand();

    DataSet ds = new DataSet();

    da.Fill(ds);

    var dataTable = ds.Tables[0];

    var dataRow = dataTable.AsEnumerable().Single(r => (int)r[0] == (int)newRow[0]);

    for (int i = 1; i < dataTable.Columns.Count; i++)
    {
        dataRow.SetField(i, newRow[i]);
    }

    da.Update(ds);
}