使用SqlBulkCopy高效批量更新数据字段

 /// <summary>
        /// 批量更新
        /// </summary>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <param name="dt">数据表</param>
        /// <param name="strwhere">条件</param>
        /// <returns></returns>
        public int  SqlBulkCopyUpdater(string connectionString, DataTable dt,string strwhere)
        {
            try
            {
                string tablaName = dt.TableName;//TL_Project_Analysis_Standards_List
                string strSQL = string.Format(" Select ID,ordernum,CODE_NO1,CODE_NO From {0} Where {1}", tablaName, strwhere);
                int obj = 0;
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    if (conn.State != ConnectionState.Open) conn.Open();
                    using (SqlTransaction trans = conn.BeginTransaction())
                    {
                        using (SqlDataAdapter adp = new SqlDataAdapter(strSQL, trans.Connection))
                        {
                            using (SqlCommandBuilder cmd = new SqlCommandBuilder(adp))
                            {
                                DataSet ds = new DataSet();
                                cmd.ConflictOption = ConflictOption.OverwriteChanges;
                                adp.SelectCommand.Transaction = trans;
                                //设置批量更新的每次处理条数 这就是批量更新
                                adp.UpdateBatchSize = 100000;
                                adp.Fill(ds);
                                try