>>I don't understand how ADO can make changes to the underlying table. I mean, in the resulting DS, assume I change the value of
>>ModuleTypeKey, which is in a JOINed table. If I then call Update, how does ADO know which table to put the changes in?
>
>>It's amazing how well my code works when I code it right! Thanks.
>
>You're welcome! =0)
>
>>A related question.
>
>>I don't understand how ADO can make changes to the underlying table. I mean, in the resulting DS, assume I change the value of
>>ModuleTypeKey, which is in a JOINed table. If I then call Update, how does ADO know which table to put the changes in?
>
>I don't think it *can* know it. Which is why I don't use the Update ... I roll my own (basically, spin through every changed row in the table you want to update, and for each of those rows set parameters and ExecuteNonQuery. It's basically what the Update does behind the scenes, but you obviously have more control over it). We've have a set of "parameter" methods that do things like automatically set parameters.

So you form a client-side Update command and send it for each row that has changed?