Here was a scenareo I came across recently. I was using a table adaptor to handle syncing the changes from a client
machine to a server. These would run stored procedures on the sql server to update the data as depending on certian
conditions some values couldn't be edited by the user (the application should deny these edits anyway but I implicitly
don't trust the user so the server gets the last word).

For the update/insert commands this works fine as they have the ability to fetch the results of a row returned as being
the results stored by the server.

Unfortunatly the delet command ignores any result returned. This is understandable if it was deleting it, but in certain
cases the server decides to reject the delete, but the client machine doesn't realise as it ignores any returned values
from the server and I could see no way to override this automatic command behaviour.

As long as the program is upto date and its logic on whether a client can remove a row this isn't a problem, but I was
curious if anyone knew a way round this default behaviour in a simple way. Otherwise the only choice would be overriding
the SqlDataAdapter or writing one's own data adapter.

Populating typed datasets WITHOUT tableadapters
problem with no rows being returned - but rows are there
Conenctivity to Interbase Database
Access File Lock
Dataset converting date field accross time zones...