批量快速插入数据

最新推荐文章于 2024-05-03 11:46:59 发布

dingtuo8679

最新推荐文章于 2024-05-03 11:46:59 发布

阅读量238

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/bin521/p/8194577.html

版权

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();
}
}

转载于:https://www.cnblogs.com/bin521/p/8194577.html