批量添加数据

public bool AddMuch(DataTable dt)
 {
            try
            {
                SqlBulkCopy sqlBulk = new SqlBulkCopy(SQLHelperTQOA.connectionString, SqlBulkCopyOptions.UseInternalTransaction);
                sqlBulk.NotifyAfter = dt.Rows.Count;
                sqlBulk.DestinationTableName = "Yugu";
                sqlBulk.ColumnMappings.Add("ShopID", "ShopID");
                sqlBulk.ColumnMappings.Add("ShopName", "ShopName");
                sqlBulk.ColumnMappings.Add("RegionID", "RegionID");
                sqlBulk.ColumnMappings.Add("YgValue", "YgValue");
                sqlBulk.ColumnMappings.Add("YgDate", "YgDate");
                sqlBulk.ColumnMappings.Add("YgAddTime", "YgAddTime");
                sqlBulk.ColumnMappings.Add("count", "count");
                sqlBulk.ColumnMappings.Add("Name", "Name");
                sqlBulk.WriteToServer(dt);
                sqlBulk.Close();
                return true;
            }
            catch
            {
                return false;
            }
            finally
            {
                dt.Dispose();
            }
   }