BULK从DataTable插入DB2 [英] BULK Insert from a DataTable to DB2

问题描述

我上传了一个excel并将数据从excel中提取到Datatable。

我的数据表大约有1000行。我的问题是如何将整个DataTable一次性插入到DB2中而不是逐行插入？



在此先感谢

Saju

I have uploaded one excel and extracted the data from excel to the Datatable.
My Datatable Having about 1000 rows. My question is How to Insert entire DataTable into DB2 at once instead of row by row?

Thanks In Advance
Saju

推荐答案

http://www.ibm。 com / developerworks / data / library / tips / dm-0403wilkins / [ ^ ]

尝试 DB2BulkCopy类 [ ^ ]

请参阅以下链接： -



http://stackoverflow.com/questions/10405373/insert-entire-datatable-into-database-at-once-instead-of-row -by-row [ ^ ]

refer below link:-

http://stackoverflow.com/questions/10405373/insert-entire-datatable-into-database-at-once-instead-of-row-by-row[^]

这篇关于BULK从DataTable插入DB2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！