Thanks. I read that and am now attempting to automatically generate the
update command. I can see that the command is created by examining:
SqlCommand com = cb.GetUpdateCommand();
However changes are still not appearing in the database when I call the
Update() method on the data adaptor instance. Examining the DataAdapter
members I notice that cmdUpdate is 'undefined value'. I have no idea why.
Are their any reasons for this that you can think of?
Many thanks.
"Brock Allen" <ba****@NOSPAMdevelop.com> wrote in message
news:b8**************************@msnews.microsoft .com...
Look into the SqlDataAdapter and its Update method.
-Brock
DevelopMentor
http://staff.develop.com/ballen
I have some data in a DataSet and want to write it back to the
underlying SQL Server database. Is there any simple "one-liner" way to
write a dataset back to its database or do I have to go through the
steps of creating a command object, adding parameters and calling
ExecuteNonQuery().
Many thanks.