批量插入数据

  /// <summary>
        /// 批量插入数据
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public void SqlBulkCopy(DataTable dt,string lei1,string lei2,string biao)
        {

            try
            {
                //startTime = DateTime.Now;
                //数据批量导入sqlserver,创建实例    SqlBulkCopyOptions.UseInternalTransaction采用事务  复制失败自动回滚
                System.Data.SqlClient.SqlBulkCopy sqlbulk = new System.Data.SqlClient.SqlBulkCopy(ConnectionString, SqlBulkCopyOptions.UseInternalTransaction);
                // sqlbulk.SqlRowsCopied +=new SqlRowsCopiedEventHandler(); //订阅复制完成后的方法,参数是 sqlbulk.NotifyAfter的值
                sqlbulk.NotifyAfter = dt.Rows.Count;

                //目标数据库表名
                sqlbulk.DestinationTableName = biao;
                //数据集字段索引与数据库字段索引映射
                sqlbulk.ColumnMappings.Add(0, lei1);
                sqlbulk.ColumnMappings.Add(1, lei2);
                //导入
                sqlbulk.WriteToServer(dt);
                sqlbulk.Close();
           
            }
            catch (Exception ex)
            {
                Log.Log.BugInfo("Member_Class类", ex.ToString(), Log.Log.GetLineNum().ToString() + "行");
            }
            finally
            {
                dt.Dispose();
            }
        }