OK, I finally get where you guys have gone.

I have learned that:

1. tableadapters are bad, datasets might be bad and the use of wizards should be avoided at all costs.
2. What has gone wrong for me is probably not reproducible.
3. That I can remediate the problem and many future problems, by creating an instance of the table, instead of using a tableadapter, and executing the query on the instance.