How to fill one dataset from another dataset RRS feed

  • Question

  • Does anyone know how to accomplish the above behavior?

    I want to update a database table from a dataset currently populated from another table.  I can iterate thru the, filled dataset, and populate the other dataset or directly insert row after row into the other table.

    I'm hoping to find a 'bulk' way to accomplish this without going row by row.

    I created one dataset and used it's tableadapter to fill dataset1.  Now I created another dataset2 with a 'select * from [other table].  Now I want to bulk insert dataset1's data into dataset2, then use the tableadapter from dataset2.update to insert rows into the other table.


    • Moved by VMazurModerator Thursday, April 8, 2010 10:03 AM (From:ADO.NET Data Providers)
    Monday, May 29, 2006 10:39 PM


All replies