Results 1 to 7 of 7

Thread: copy datagrid to table

  1. #1

    Thread Starter
    Addicted Member Halon's Avatar
    Join Date
    Oct 2002
    Location
    under desk choking on rage
    Posts
    228

    copy datagrid to table

    I have a datagrid that i have populated from a sql server 200 database. Once the user modifies the data it is to be saved into a new table. How would i go about doing this.?
    I have tried to populate a dataadapter with the data, then save it to a ataset and then to the table but have no idea how to start.

    I would usually just
    Code:
    myDataAdapter.Update(myDataSet, "infoTrack_Supplier")
    update the adapter to save the changed data but i need all new info saved to new table.

    Thanks for any ideas
    Soylent Green tastes like chicken

  2. #2
    Frenzied Member DevGrp's Avatar
    Join Date
    Nov 2001
    Location
    Charlotte, NC
    Posts
    1,256
    Is the new table already in the DB?

  3. #3

    Thread Starter
    Addicted Member Halon's Avatar
    Join Date
    Oct 2002
    Location
    under desk choking on rage
    Posts
    228
    Yes it is
    Soylent Green tastes like chicken

  4. #4
    Frenzied Member DevGrp's Avatar
    Join Date
    Nov 2001
    Location
    Charlotte, NC
    Posts
    1,256
    Ok, I'll do a quick demo when I get home.

  5. #5

    Thread Starter
    Addicted Member Halon's Avatar
    Join Date
    Oct 2002
    Location
    under desk choking on rage
    Posts
    228
    Thanks for the help DevGrp!
    Soylent Green tastes like chicken

  6. #6
    Frenzied Member DevGrp's Avatar
    Join Date
    Nov 2001
    Location
    Charlotte, NC
    Posts
    1,256
    Here ya go. This was compile with VS.NET 2003 BTW
    Attached Files Attached Files

  7. #7

    Thread Starter
    Addicted Member Halon's Avatar
    Join Date
    Oct 2002
    Location
    under desk choking on rage
    Posts
    228
    haven't had a chance to run with it yet...but thanks for the file!!
    Soylent Green tastes like chicken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width