Click here to Skip to main content
15,668,517 members
Articles / Database Development / MySQL

Tagged as


4 bookmarked

Generate Multiple Insert Command from a .NET DataSet to MySql

Rate me:
Please Sign up or sign in to vote.
2.33/5 (2 votes)
10 Jul 2016CPOL3 min read
Dynamically generate SQL INSERT commands programmatically and run then in batches of hundreds to bulk load data from a .NET DataSet with multiple DataTables to MySql
This article show you how to dynamically build SQL insert statements from a set of data tables inside a data set and run them in parametrized batches to load the data into MySql Server tables with a huge performance than running it row by row.


Daily Counts


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Spain Spain
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions