CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5

Threaded View

  1. #1
    Join Date
    May 2008
    Posts
    7

    Best way to write DataSet to database table

    Referring to my previous thread i would be interested to know your opinion about what's the best, most efficient approach for writing a method that would accept three parameters:

    1) database connection
    2) DataSet
    3) name of a table in database

    and write the content of the DataSet's Table[0] to an empty, structurally identical database table?

    The passed DataSet-parameter would be filled with loads of data. With the method i have described in my previous post, using DataAdapter.Update, it takes about 1 minute to insert 10 000 rows and that's just way too slow.
    Last edited by cokelite; May 14th, 2008 at 02:20 PM.

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

Featured