Konrad:
If your table isn't keyed, niether the DataAdapter Configuration wizard or
the CommandBuilder is going to be successful generating update logic. You
can run selects off of an unkeyed table, but that's about it. The Key that
you create client side will enforce integrity, but the back end doesn' tknow
about it.
Is the Non-Key thing on the backend a requirement? Stated humbly, there
probably aren't too many instances where not having a key is value
added.......and there are many shops where having a Key on every table is a
requirement. It'll definitely make your life easier.
Nonetheless, if you don't have a key and can't put one on it, you'll need to
roll out your own update logic which is doable, but can be a little work
depending on your table.
Cheers,
Bill