循环写入Insert 与 SqlBulkcopy
时间：2021-07-01 10:21:17
帮助过：14人阅读
Insert by Loop */
cmd.CommandText =
"insert into BizSharedStore (BizSharedStoreId,BizSharedId,StoreCode,StartDt,EndDt) values (@BizSharedStoreId,@BizSharedId,@RuleCode);";
cmd.CommandType =
CommandType.Text;
foreach (
var x
in query_BizSharedList)
{
try
{
cmd.Parameters.Clear();
cmd.Parameters.Add("@BizSharedListId", SqlDbType.VarChar).Value =
x.BizSharedListId.ToString();
cmd.Parameters.Add("@BizSharedId", SqlDbType.VarChar).Value =
x.BizSharedId;
cmd.Parameters.Add("@RuleCode", SqlDbType.VarChar).Value =
x.Rulecode;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Insert BizShardList Error:" +
ex.Message);
}
}
// End of Insert by Loop
MessageBox.Show("insert into BizSharedList by Insert Loop, Successfully!");
SqlBulkcopy
using (SqlBulkCopy bulk1 = new SqlBulkCopy(conn))
{
bulk1.DestinationTableName = "BizSharedList";
//bulk1.ColumnMappings.Add("BizSharedListId", "BizSharedListId");
//bulk1.ColumnMappings.Add("BizSharedId", "BizSharedId");
//bulk1.ColumnMappings.Add("RuleCode", "RuleCode");
bulk1.WriteToServer(tbl_BizSharedList);
}
MessageBox.Show("Bulk Insert Table: BizSharedList Successfully!");
循环写入Insert 与 SqlBulkcopy
标签：sql lis blog query values cat arc exec store
