updatecommad RSS

• • Reply
  

  onetjn

  Member

  57 Points

  36 Posts

  updatecommad

  Sep 07, 2011 05:48 PM|LINK

  I created a dataset with 3 tables

  I would like to run updates on all 3 tables

  Is it possible to have 3 different update commands (1 for each table) held by the data adaptor simultaneuously?

  ie.

  dataAdaptor.updatecommand = uc1;

  dataAdaptor.updatecommand = uc2;

  dataAdaptor.updatecommand = uc3;

  I immagine in the above example uc3 is the only update command in the dataadaptor

  you can batch sql queries ie.

  sql = "selelct * from table1;select * from table2;select * from table3;";

  to create the dataset.  Is there some kind of concatenated update statement?

  In my situation I go through each table seperately and make modification visa vi

  record.beginupdate

     update record here

  record.endupdate

  when all is said and done inserts, updates, deletes for all the different tables

  I want to execute 1 dataadaptor.update

  I am trying to avoid having to do a complicated join for the update commands.

  any help here would be appreciated

• • Reply
  

  chohmann

  Star

  9385 Points

  1644 Posts

  Re: updatecommad

  Sep 07, 2011 06:45 PM|LINK

  No, DataAdapters can only update one table. Here's a link:

  http://stackoverflow.com/questions/5889102/ado-net-updating-multiple-datatables

  Please mark as answered if this helped.
  • Marked as answer by decker dong - msft on Sep 13, 2011 03:07 AM