|
-
May 14th, 2008, 11:26 AM
#1
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|