C#使用SqlBulkCopy批量复制数据到数据表

 {
     con.Open();
 }
 SqlBulkCopy topbranddtcopy = new SqlBulkCopy(con);
 topbranddtcopy.DestinationTableName = destinationtablename;
 topbranddtcopy.WriteToServer(sourcedt);
 con.Close();
    }
    catch (Exception ex)
    {
 Logger.Error("批量新增数据:" + destinationtablename + "," + ex.ToString());
    }
}

 

完整调用代码：

 

复制代码 private void CreateTopBrandData(int date, int cid, List<BrandSellDataItem> brandselldataitems)
{
    try
    {
 var dt = bisdal.From<TopBrand>(TopBrand._.ID == -1, OrderByClip.Default).ToDataTable();
 foreach (var item in brandselldataitems)
 {
     try
     {

 

  TopBrand topbrand = new TopBrand
  {
      BrandIndex = item.mk,
      BrandName = item.c58,
      Date = date,
      WinnerAmt = item.c60,
      WinnerPeople = item.c62,
      WinnerProNum = item.c61,
      HotTaobaoCategoryID = cid
  };
  CreateDtByItem<TopBrand>(topbrand, dt);
     }
     catch (Exception ex)
     {
  Logger.Error(ex.ToString());
  continue;
     }
 }
 BulkWriteToServer(con, "TopBrand", dt);
    }
    catch (Exception ex)
    {
 throw new Exception("CreateTopBrandData:" + ex.ToString());
    }
}

 

希望本文所述对大家的C#程序设计有所帮助。