批量快速插入数据

 mysql语法:insert into userinfo(LoginName) values('1234'),('1235'),('1236') ,('1237')

sql语法:insert into userinfo(LoginName) values('1234')insert into userinfo(LoginName) values('1234')......
StringBuilder sqlsb = new StringBuilder();   往sql书库据批量添加
StringBuilder mysql = new StringBuilder();  往mysql书库据批量添加
for (int i = 0; i < dt.Rows.Count; i++)
{

sqlsb.Append("insert into Sys_HuoYun(ObjectID,Kind) values(" + Convert.ToInt32(dt.Rows[i]["OrderID"]) + ",4)");
if (string.IsNullOrEmpty(mysql.ToString()))
{
mysql.Append("INSERT INTO orderdetail(OrderID,ProductCode,ProductName,TradePrice,ProductCount) VALUES");
}
mysql.Append("(" + Convert.ToInt32(dt.Rows[i]["OrderID"]) + ",'" + dt.Rows[i]["产品编码"] + "','" + dt.Rows[i]["产品名称"].ToString().Replace('\'', ' ') + "'," + dt.Rows[i]["成交单价"] + "," + Convert.ToInt32(dt.Rows[i]["成交数量"]) + "),");
if ((i + 1) % 1000 == 0)
{

SqlHelper.ExecuteNonQuery(CommandType.Text, sqlsb.ToString());
MySqlHelper.ExecuteNonQuery(MySqlHelper.connectionStringManager, CommandType.Text, mysql.ToString().Substring(0, mysql.Length - 1));      //去掉最后那个，号。

sqlsb.Clear();
mysql.Clear();
}
}